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 |
|
krishna
Starting Member
1 Post |
 Posted - 2003-09-30 : 08:53:55
|
| hello our database is getting into suspect status sometimes.After searching and with help we are recovering but some transactions are missing.Is there any way to recover database without loss of any records.Please provide me some solution.Very urgentThanking youregardskrishna |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-09-30 : 09:27:16
|
| If you are set to full recovery then you can back up the tr log and restore the last backup and all tr logs. It's explained in bol.More important should be to find out why the database is failing and fix that.==========================================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. |
 |
|
|
ananth_singar
Starting Member
3 Posts |
Posted - 2003-10-01 : 02:59:21
|
| This can also happen when there is insufficient space for the file to grow. First fix it up.sp_resetstatus 'dbname', 'true' can be used to change the suspect status and then use recovery.Ananth-India |
|
|
|
|
|
|
suspect status