Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- ===========================
- -- Backup Database Template
- -- ===========================
- BACKUP DATABASE <Database_Name, sysname, Database_Name>
- TO DISK = N'<Backup_Path,,C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLBackup><Database_Name, sysname, Database_Name>.bak'
- WITH
- NOFORMAT,
- COMPRESSION,
- NOINIT,
- NAME = N'<Database_Name, sysname, Database_Name>-Full Database Backup',
- SKIP,
- STATS = 10;
- GO
Add Comment
Please, Sign In to add comment