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.
:)
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 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
:)