Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sumit.dhankhar
Starting Member
1 Post |
 Posted - 2009-04-06 : 06:12:14
|
| how can i shring a .bak file and restore that to my database |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-06 : 07:21:57
|
| If you mean "shrink", you can't shrink a backup file. If you want smaller backup files you'll need to get a compression utility like SQL Litespeed or Red Gate's backup utility, or upgrade to SQL Server 2008 Enterprise Edition. |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-04-06 : 10:28:54
|
| or...zip / rar it up store the zip and if you need to restore unzip / unrar it first.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
shring a backup(.bak) file