Tagged Questions
0
votes
1answer
84 views
Is it there anyway to restore updated records in Microsoft SQL Server 2008 R2?
We have an test database configured with our web application. Due to internal web application error the entries were get updated in the database. Is it there any way to recover the updated records?
...
4
votes
1answer
164 views
Electricity off while shrinking database, how can I recover my database?
While i execute shrink database, the electricity has been gone down, I can't access my database now, it is (In Recovery), how can i recover it?? Note: it is a very huge database: 25 GB.
EDIT:
My ...
4
votes
3answers
673 views
RSync Database File Deltas in SQL Server 2008
Alright, I feel like this is a terrible idea, but I need some help understanding why this is bad:
I'm still working on implementing a disaster recovery/business continuity solution for our ...
1
vote
1answer
78 views
SQL ServerRecovery Model Change Tracking
Are SQL Server recovery model changes logged anywhere...WMI, error logs...etc?
For instance, if I change from FULL to SIMPLE, is this recorded anywhere?
9
votes
2answers
1k views
Restore bak file to smaller mdf and ldf database files
I have a legacy database whose nightmarish lack of design I will not get into here, but the files on the server are (relatively) enormous. I have:
MyDatabase.mdf: 24.8GB
MyDatabase.ldf: 114.6GB
This ...
1
vote
3answers
237 views
Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?
We are having an ETL process which inserts lots of data into tables. This database is set to Simple Recovery Model and the transaction log is growing a lot. I was thinking that would it help to set ...
16
votes
3answers
11k views
How do I get back some deleted records?
I mistakenly deleted around 2,000,000 records from a remote SQL Server 2008 table. The server is not granting me access to the backup files on the server side.
Is there any way to get back these ...
