Advertisement
Guest User

Untitled

a guest
Oct 27th, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. Select a.name, b.physical_name
  2. from sys.databases a
  3. join sys.master_files b
  4. on a.Database_id = b.database_id
  5. Where a.name = 'NAME_OF_YOUR_DATABASE'
  6.  
  7. BACKUP Database NAME_OF_YOUR_DATABASE
  8. To Disk = N'C:DatabasesNAME_OF_YOUR_DATABASE.bak With Compression
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement