Viewing 15 posts - 17,191 through 17,205 (of 49,552 total)
What list are you talking about?
If the list that the SSMS restore dialog brings up, that's just the backup history in MSDB. You can use SQL Agent with the backup...
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
August 13, 2012 at 12:01 pm
SQL recovers all databases every time it starts. It's not something that happens in a disaster, it's a normal operation on startup.
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
August 13, 2012 at 12:00 pm
Two things:
SQL encounters a corrupt database page or log record when doing a rollback of a transaction
SQL encounters a corrupt database page or log record during crash recovery (when opening...
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
August 13, 2012 at 10:43 am
hy124807 (8/13/2012)
It was indeed a little bit disappointed after I did lots search on the internet for these exams after they were released in June:cool::cool:.
Patience. People writing material for...
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
August 13, 2012 at 10:42 am
tilew-948340 (8/13/2012)
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
August 13, 2012 at 10:38 am
You're referencing a linked server that doesn't exist. Either modify your code and fix the linked server reference or add the linked server.
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
August 13, 2012 at 9:19 am
Because your database is in full recovery model. When a database is in full recovery SQL assumes you care about the data and don't want to lose any by accidentally...
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
August 13, 2012 at 8:05 am
The message is warning you that there are transactions in the log that will be lost if you restore. It's a safety net. The assumption is, if the DB is...
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
August 13, 2012 at 6:34 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1344086-1292-1.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
August 13, 2012 at 6:11 am
Personally I never use the copy database wizard. It's an expensive, slow way of doing what backup/restore (or detach-copy-attach) does. Probably the only time I'd use the wizard is for...
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
August 13, 2012 at 6:09 am
If you're trying to copy a DB to another instance, why not backup/restore?
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
August 13, 2012 at 5:51 am
That's what sys.dm_exec_procedure_stats is for. It's a sub-set of query stats that just shows procedures.
Views don't have plans, so you'll never see a view alone in any of the query...
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
August 13, 2012 at 5:45 am
Assuming of course that the procedure's plan was ever cached, has not been aged out of cache and the SQL instance hasn't been restarted since
The plan cache will give you...
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
August 13, 2012 at 4:52 am
surishetty_shiva (8/13/2012)
Is it possible to get latest dumps?
Braindumps are cheating. They are actual questions taken from the exams in violation of the NDA that all exam takers must accept. Using...
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
August 13, 2012 at 4:48 am
You mean the last stored procedure that's been run in a DB? Unless you have some auditing or tracing running, there's no reliable way to determine that.
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
August 13, 2012 at 4:00 am
Viewing 15 posts - 17,191 through 17,205 (of 49,552 total)