Guest User

Untitled

a guest
Jul 20th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. -- ===========================
  2. -- Backup Database Template
  3. -- ===========================
  4. BACKUP DATABASE <Database_Name, sysname, Database_Name>
  5. TO DISK = N'<Backup_Path,,C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLBackup><Database_Name, sysname, Database_Name>.bak'
  6. WITH
  7. NOFORMAT,
  8. COMPRESSION,
  9. NOINIT,
  10. NAME = N'<Database_Name, sysname, Database_Name>-Full Database Backup',
  11. SKIP,
  12. STATS = 10;
  13. GO
Add Comment
Please, Sign In to add comment