Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select a.name, b.physical_name
- from sys.databases a
- join sys.master_files b
- on a.Database_id = b.database_id
- Where a.name = 'NAME_OF_YOUR_DATABASE'
- BACKUP Database NAME_OF_YOUR_DATABASE
- To Disk = N'C:DatabasesNAME_OF_YOUR_DATABASE.bak With Compression
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement