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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2008-01-10 : 15:10:55
|
| DATABASE in Full ModeRun TRANSACTION LOG Backups 15 minutes.If for some reason i want to shrink the LOG file back to size.The only way i can do this isBACKUP LOG nologtest TO DISK = 'c:\nologtest1.trn' WITH INIT;Then issue this commandBACKUP LOG nologtest WITH NO_LOG;Then i can issue the DBCC SHRINKFILE (nologtest_log, 2);I cannot seem to shrink the log file unless i issue theNO_LOG first statement. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-10 : 23:48:52
|
| Depends on virtual log file location. |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-01-11 : 10:22:45
|
| What does virtual log file location mean. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-11 : 10:26:36
|
| http://msdn2.microsoft.com/en-us/library/ms189085.aspx_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-01-11 : 10:42:22
|
| Gets complicated switching from Simple Mode to Full Mode. |
|
|
|
|
|
|
Clarification on Backup TRN