[Guide] Backup DB (Query Analyzer)

[Gasolincho]

Dear Darks,

Sample script to backup your database with Query Analyzer.

#1. Open
*StartMenu->Programs->Microsoft SQL Server->Query Analyzer

#2. Copy script from DarksTeam.net

USE master;
GO
BACKUP DATABASE MuOnline
TO DISK = 'D:\MuServer\backups\MuOnline-backup.Bak'
   WITH FORMAT,
      MEDIANAME = 'DarksTeam',
      NAME = 'Full Backup of MuOnline MSSQL script www.darksteam.net';
GO

#3. Select database MuOnline
*Execute the script

After all this your backup will be in D:\MuServer\backups\, but of-course you must have that folder.

Thanks, Gaso.

 

[Dungeon]

Мерси много , ето че имало и по лесен начин. 10/10

 

[oveRLuckEd]

браво, добра работа, ама предпочитам дясно копче и backup database

 

[OmaRuCat]

Много добра работа но и аз предпочитам по "стандартния" начин .

 

[NoFeaR]

Благодаря ти Гасо ако не беше ти незнам как щях да направя бекъп-а мн добър скрипт.
И благодаря за помоща още веднъж Гасо.

 

[mi7aka2]

Thanks!

 

[hopara]

Много полезно мерси !!!

 

[NEMES1S]

Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'D:\MuServer\backups\MuOnline-backup.Bak'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.