Unanswered: How to backup/restore entire database in easiest way?
I'm found this sample for BACKUP DATABASE statement in SQL Server 2000 Book
Online, but is seemed that only save file to server. How can I save backup
file to local computer? or there is other way as easy as this statement for
-- Create a logical backup device for the full MyNwind backup.
EXEC sp_addumpdevice 'disk', 'MyNwind_1',
DISK ='c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_1.dat'
-- Back up the full MyNwind database.
BACKUP DATABASE MyNwind TO MyNwind_1
I usually map network disk. For this I change job of Maintenance Plan:
exec xp_cmdshell 'net use W: \\Backup_Server\DB_Backup'
EXEC master.dbo.xp_sqlmaint N'-PlanID 1C7C4AA1-A06B-42CF-8985-3C62BB8E31DB -To "mwolf" -Rpt "C:\Program Files\Microsoft SQL Server\MSSQL\LOG\Backup all job DB on Backup_Serve.txt" -DelTxtRpt 5DAYS -VrfyBackup -BkUpMedia DISK -BkUpDB "W:" -DelBkUps 5DAYS -BkExt "BAK"'
exec xp_cmdshell 'net use W: /DELETE'