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 |
|
Andersony
Starting Member
1 Post |
 Posted - 2008-01-09 : 03:54:02
|
| I found out the battery in my UPS isn't working anymore. My server down a couple of times with power outages before I figured out it wasn't doing its job.I make backups of my Sharepoint databases using the gui interface in Sharepoint, so I have backups and have used them for a couple of the outages.What I was wondering (I'm a newb to SQL), if I do a checkdb and get no errors when the databases (sharepoint_config and sharepoint_data) are marked suspect, is there an easy way to get them back online without using the backups. The only reason I ask, there is data entered in the 23hrs (daily backups) since the last backup that I wouldn't mind keeping.Also, I seem to have gotten (from reading some of the posts here) my sharepoint_config stuck in emergency mode and can't find a post on how to get it back to normal/online mode ;) -Sony |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-09 : 22:30:37
|
| If it caused by disk related problem, rebooting server may fix it. You better to do log backup, so can perform point of time recovery. |
 |
|
|
|
|
|
Sharepoint and SQL Express 2005