Viewing 15 posts - 27,916 through 27,930 (of 49,552 total)
lordmwesh (2/5/2011)
We are going to look for tools that can recover files even if overwritten from a certain point.
By all means try, but I have not seen a database...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 5, 2011 at 10:07 am
That's a pretty big question. Entire books have been written on the subject.
Start with these
Then try Grant's book
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 5, 2011 at 6:33 am
Database snapshot?
Are there long-running transactions at the time you create them?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 5, 2011 at 1:56 am
Run a manual checkpoint, see if it helps
CHECKPOINT
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 5, 2011 at 1:55 am
Someone ran ALTER DATABASE ... SET SINGLE_USER. However the error looks more like the entire instance is in single user mode. That would require someone to have added the -m...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 5, 2011 at 1:54 am
Keith Langmead (2/4/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2011 at 3:32 pm
Carlton B Ramsey (2/4/2011)
If somone could post a good tutorial on this it would be benifitial. I couldn't find one with a quick search.
Managing Transaction Logs[/url]
However a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2011 at 2:38 pm
loki1049 (2/4/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2011 at 2:37 pm
loki1049 (2/4/2011)
Make absolutely sure you don't need anything in your database before you restore it.
Is this to say that it will just restore the structure of the database?
No. It's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2011 at 2:36 pm
loki1049 (2/4/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2011 at 2:08 pm
shaun.stuart (2/4/2011)
Hi Gail.. I'm just following along at home. Can you tell me how you can tell that the database was from 2005 or 2000?
2011-02-04 20:30:23.42 spid53 During upgrade, database...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2011 at 1:08 pm
Errr, no.
http://technet.microsoft.com/en-us/library/ms189850%28SQL.90%29.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2011 at 12:47 pm
Craig Farrell (2/4/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2011 at 12:36 pm
No, you do need a witness for auto failover.
Providing you're using synchronous mirroring and the state is synchronised, once the principal is down you should be able to bring the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2011 at 12:34 pm
It's just telling you that the DB you're restoring over is in full recovery and the tail of the log has not been backed up and hence you will lose...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 4, 2011 at 12:30 pm
Viewing 15 posts - 27,916 through 27,930 (of 49,552 total)