2
votes
1answer
201 views

Electricity gone off while shrinking database, how can I recover my database?

While executing a shrink on a 25GB database, the electricity has gone down, and I can't access my database. It shows as "In Recovery". How can I recover it?
1
vote
2answers
1k views

SQL Server database filled the hard drive and freeing up space isn't possible

I have a database in SQL Server 2008 on a 1Tb hard drive and it filled the drive, there is only 4Kb free. The MDF file is 323Gb and the LDF is 653Gb. The hard disk this DB is on has no other files on ...
0
votes
1answer
240 views

How to diagnose SQL Server database spontaneously going into Recovery mode

We have a large SQL Server database (approximately 1G) which will spontaneously go into Recovery mode several times per day. This apparently happens only when there are a significant number of ...
1
vote
1answer
605 views

Sharepoint - restore single document from database level backup

Have a single Sharepoint webserver backed by a SQL 2005 server. The sharepoint server has a messed up document in a document library and I have a SQL database backup from the day before. What are my ...
0
votes
2answers
211 views

How to recover/restore SQLServer 2005 databases from MDF/LDF files

I have a SQL DB instance that was stopped/shut down improperly and the msdb system db along with the regular DBs have been "in recovery" for over 2 weeks now. sometimes after a reboot one DB in the ...
0
votes
3answers
522 views

sql server 2005 instance unresponsive and all db's are 'in recovery'

we've got a sql server 2005 instance that one of our guys messed up, i believe they killed the sql server service and restarted the computer, and when it came back all of our databases are "in ...
0
votes
1answer
227 views

Recovery models, log shipping and log backup frequency in SQL05

Trying to get a sense of the optimal setup in our environment. I have a large SQL05 DB (500+GB) that is log shipped to a read-only system over a WAN. I'm currently running in FULL recovery model, ...
0
votes
3answers
604 views

SQL Server rolling forward lots of transactions, what should I look at?

I am running SQL Server Express on a Windows XP Embedded box. It runs for a day or two, doing some transactional processing for a POS type system, and with another system pulling data out to an OLAP ...
0
votes
1answer
2k views

How do you switch an active SQL Server database into Simple Recovery Mode

I've had some logging problems and based on the way the application works we don't need full recovery mode, which will help us with our logging. How do I switch the database into simple recovery ...