April 8, 2009 at 1:18 am
How to know is the backup file is compressed while taking backup from database.
Ex: I have a sql server 2008 .bak file.
How to know that file in compressed backup file.
Thanks,
KK
April 8, 2009 at 1:41 am
In the backupmediaset[/size][/u][/i][/b] table, the is_compressed column tells you whether or not the backup is compressed.
Tanx 😀
April 8, 2009 at 2:39 am
where the backup has taking that server is not with us. We have only .bak file
Thanks,
Kishore KK.
April 8, 2009 at 6:38 am
Run the RESTORE ... HEADERONLY. That will tell you all you need to know about the .BAK file itself. Then you can also run RESTORE... FILELISTONLY to get the file structures for the restore.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply