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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-09 : 09:32:10
|
| sreenivas writes "after restoring database backup of file size 54GB,transaction log(ldf) size occupying above 5GBis there any way to reduce the log size while restoring the database it self.my database is in full recovery." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-09 : 10:24:00
|
| It will restore the tr log to the size it was when the database was backed up. You can only shrink it after the restore (or before the backup).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sreenivasa.rao
Starting Member
3 Posts |
Posted - 2006-08-10 : 05:44:24
|
| before full backup the transaction log size is 237 MB in production but after restoring the backup in reporting server transaction log is size 5.67GB ,shrinking is only way after restore any other way to reduce the size after restore in reporting server the same backup of production |
|
|
|
|
|
|
to reduce transaction log while restoring backup file