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 - 2003-01-15 : 14:57:58
|
| A.lfred writes "I try to shrink transaction log, and yes it works. The code I use shown below :USE [5000_SID]BACKUP LOG [5000_SID] WITH TRUNCATE_ONLYGOdbcc shrinkfile ([5000_SID_log])GOThe sql server is 2000 with Windows 2000 Server sp.1Question i like to ask are =1. Which one is more effective if compare by using the sp_detach_db & sp_attach_db (or just the same)?2. What is the drawback using my code ?3. Where is the backup log file store, coz no backup file found in the folder where usually store the mdf and ldf." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-15 : 17:21:22
|
| 1. dettach/attach will always revert to default size but means taking the database offline2. see 1 - if it works then go with it but do a full backup first.3. try BackupDirectory registry key under KEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer.==========================================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. |
 |
|
|
|
|
|
Yes, it's transaction Log question, but ..