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 |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2008-07-01 : 05:35:26
|
| hii have sheduled restore database use log(.TRN) file. the database is stand by and read only mode. after restoring log file increse the size of log(.ldf) file. so i have use dbcc shrinkfile to minimize size of log(.ldf) file. but the shrink file is not posible to readonly mode.so how can i posible shrink file of database. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-07-01 : 08:25:05
|
| Already asked here:[url]http://www.sqlservercentral.com/Forums/Topic526487-146-1.aspx[/url]--Gail Shaw |
 |
|
|
|
|
|
DBCC Shrinkfile of database in sql2005