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 - 2002-11-29 : 09:42:03
|
| Mala writes "Hi,What could be wrong if i get 'SUSPECT' next to my databse and what I have to do to eliminate that.I also would like to know how can i detach a primary log file and attach new log file as my primary log file. Many times we are facing problem like log is full [now we have set it to truncate at check point] , take backup and truncate log file. But how much ever we shrink the log file [it will come to 1/4 of it's size when we shrink it], but when we execute some query on a table whcih has got huge data, it gives the same message. How can we solve this. Bye,Mala" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-29 : 12:45:00
|
| Are these two questions connected?Suspect means that the system cannot recover the database and you should restore the last backup. You can reset the suspect bit and hope but...To shrink log files I find it easier to detach the database, delete the log files then attach (after a backup of course).To solve the problem you will have to change the query so that it doesn't do a lot of updates in a single transaction then you can commit and truncate the log as you go.==========================================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. |
 |
|
|
|
|
|
SUSPECT database