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 |
|
cornall
Posting Yak Master
148 Posts |
 Posted - 2007-08-02 : 05:59:08
|
| My backup server has a 13 gig log file. It is a read only log shipped database. Is there anyway to shrink the log file? The database has a log restored to it ever 5 mins.Cheers |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-08-02 : 06:26:40
|
| The log file will be the same size as the master database, won't it?Its not going to effect he size of the log shipping files, only the LDF file itself.Kristen |
 |
|
|
cornall
Posting Yak Master
148 Posts |
Posted - 2007-08-02 : 07:32:47
|
| yeah just wondered if I could shrink the LDF file on the destination server? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-08-02 : 08:28:01
|
| Not unless you are also going to shrink it on the Master database too, and that will break the backup chain [I think] so you'll have to re-initiate log shipping.If the LDF size isn't troubling you for disk space then I recommend you live with it!Kristen |
|
|
|
cornall
Posting Yak Master
148 Posts |
Posted - 2007-08-02 : 09:34:07
|
| seems stupid that a read only DB needs a transaction log the same size as the master DB!! You think it could live without the transaction log until the db is brought online! or is it me being stupid!! LOL |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-08-02 : 12:13:37
|
| "You think it could live without the transaction log until the db is brought online!"Well, if the TLog file is minimal size when the system comes live it will then immediately have to start extending it, which will cause physical fragmentation of the file, and potentially a performance hit too. And at least if it is pre-sized nothing else can have that disk space - so when the system comes live you won't THEN discover that you don't have enough disk space!Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-02 : 23:40:48
|
| Even target db is read only, but still get all transactions via log shipping. |
|
|
|
|
|
|
log file size on log shipped destination server