Backup der DB / Backup than DB

02/06/2015 23:12 DuZzi#1
hey ich würde gern ein backup meiner datenbank erstellen.
ich öffne die Backup.sql und bekomme volgendes ?

Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\PS_GMTool.bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\PS_UserData.bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\GameLog.Bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\PS_GameDefs.bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
Msg 945, Level 14, State 2, Line 2
Database 'PS_GameData' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ChatLog.Bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\PS_Billing.bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.

wie könnt ich das beheben ?




hey i would like to create a backup of my database.
I open the Backup.sql and get device you?

Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\PS_GMTool.bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\PS_UserData.bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\GameLog.Bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\PS_GameDefs.bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
Msg 945, Level 14, State 2, Line 2
Database 'PS_GameData' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ChatLog.Bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\PS_Billing.bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.

how can I fix this?

sorry for my bad english, goole translator.
02/07/2015 00:04 Cansas59#2
editiere mal die sql mit notepad oder so und änder den pfad dort,könnte vlt klappen
02/08/2015 17:49 DuZzi#3
läuft schon habs hinbekommen danke.