If you change the places the C drive in the code writes,it takes the drive back up.
We also recommend that you open the Backup folder before you take the backup.
IF db_id('PS_GMTool') IS NOT NULL
BACKUP DATABASE [PS_GMTool] TO DISK = N'C:\Backup\PS_GMTool.bak' WITH NOFORMAT, NOINIT, NAME = N'PS_GMTool-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 100
GO
IF db_id('PS_UserData') IS NOT NULL
BACKUP DATABASE [PS_UserData] TO DISK = N'C:\Backup\PS_UserData.bak' WITH NOFORMAT, NOINIT, NAME = N'PS_UserData-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 100
GO
IF db_id('PS_GameDefs') IS NOT NULL
BACKUP DATABASE [PS_GameDefs] TO DISK = N'C:\Backup\PS_GameDefs.bak' WITH NOFORMAT, NOINIT, NAME = N'PS_GameDefs-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 100
GO
IF db_id('PS_GameData') IS NOT NULL
BACKUP DATABASE [PS_GameData] TO DISK = N'C:\Backup\PS_GameData.bak' WITH NOFORMAT, NOINIT, NAME = N'PS_GameData-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 100
GO
IF db_id('PS_Billing') IS NOT NULL
BACKUP DATABASE [PS_Billing] TO DISK = N'C:\Backup\PS_Billing.bak' WITH NOFORMAT, NOINIT, NAME = N'PS_Billing-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 100
GO
IF db_id('PS_StatData') IS NOT NULL
BACKUP DATABASE [PS_StatData] TO DISK = N'C:\Backup\PS_StatData.bak' WITH NOFORMAT, NOINIT, NAME = N'PS_StatData-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 100
GO
IF db_id('PS_STATICS') IS NOT NULL
BACKUP DATABASE [PS_STATICS] TO DISK = N'C:\Backup\PS_STATICS.bak' WITH NOFORMAT, NOINIT, NAME = N'PS_STATICS-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 100
GO
IF db_id('PS_ChatLog') IS NOT NULL
BACKUP DATABASE [PS_ChatLog] TO DISK = N'C:\Backup\PS_ChatLog.bak' WITH NOFORMAT, NOINIT, NAME = N'PS_ChatLog-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 100
GO
IF db_id('PS_GameLog') IS NOT NULL
BACKUP DATABASE [PS_GameLog] TO DISK = N'C:\Backup\PS_GameLog.bak' WITH NOFORMAT, NOINIT, NAME = N'PS_GameLog-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 100
GO
Backup der DB / Backup than DB 02/08/2015 - Shaiya PServer Development - 2 Replies 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...
Holo Backup- adb unable to connect for backup? 07/21/2014 - Smartphones - 2 Replies Bin gerade am Sichern meines Handys, doch wenn ich Holobackup starte kommt immer:
adb unable to connect for backup
Kann mir da jemand weiterhelfen der sich auskennt?
[BACKUP]brauche backup des map ordners 03/19/2010 - Metin2 Private Server - 0 Replies hey e*pvp commu
ich suche grad ein backup für den map ordner da ich bei meinen die maps 1 und 2 total verwüstet habe und alles durcheinander ist wäre schön wenn mir einer die maps 1 und map2 von rot gelb und blau uploaden könnte oder mir direkt den ganzen map ordner thx
[Backup] Wie importiere ich einen Backup? 10/15/2009 - Metin2 Private Server - 12 Replies Hallo Leute,
also ich konnte einen Backup von meinem Server machen,...nun gut
Eines Tages ging mein Server nicht mehr (Connection refused)
Ergebnis: die Item-Tabelle ist kaputt (wer welche Sachen hat, EQ etc.)
Nun wollte ich meinen Backup wieder in die Datenbank importieren, doch das klappt irgendwie nicht...