Viewing 15 posts - 24,106 through 24,120 (of 49,552 total)
Look through the SQL error logs, there will be messages saying why the DB could not be opened. Post all of those messages here.
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 18, 2011 at 2:27 am
awu (8/17/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
August 18, 2011 at 2:15 am
Don't draw conclusions from one execution.
Run either one a few times, you may well see the CPU time vary, it happens.
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 18, 2011 at 2:13 am
http://technet.microsoft.com/en-us/sqlserver/gg429796.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 18, 2011 at 2:06 am
Query sys.databases, what's the state_desc for that 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
August 18, 2011 at 2:06 am
Books Online is your reference.
As for an alternative, the alternatives you've listed have the same problem, once the second server (R2) becomes the active server you cannot in any way...
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 17, 2011 at 3:25 pm
It'll work, partially. It is not a supported config, it's not supposed to be used for anything other than a rolling upgrade and if the mirroring ever fails over 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 17, 2011 at 2:09 pm
Generally the best job is still manual. If you want to give it a try, see these links then the book Grant has in his sig.
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 17, 2011 at 1:43 pm
Please post new questions in a new thread. Thanks
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 17, 2011 at 12:05 pm
No. That setup is supported only during an upgrade and only with 2008 as the principal and 2008 R2 as the mirror (the other way around will not work at...
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 17, 2011 at 11:59 am
You should not need updateusage on a 2005 sp3+/2008/2008 R2 instance. The page space bugs are supposed to all be fixed. If you encounter one (not an upgrade from pre...
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 17, 2011 at 11:57 am
It's consistent as of the end of the data-copying portion of the backup. Not necessarily the end of the backup, thought usually close to it.
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 17, 2011 at 10:04 am
DBCC UpdateUsage fixes page space information, nothing else. There were bugs in the the page space tracking algorithms on SQL 2000 and before, hence it was necessary to run UpdateUsage...
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 17, 2011 at 9:18 am
If anyone here thinks they're dealing with big data, go listen to this: http://dotnetrocks.com/default.aspx?showNum=664
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 17, 2011 at 7:07 am
Just be careful, I've had a case where a 'data recovery' tool could see the tables, but when we paid for the full version all it got back for us...
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 17, 2011 at 6:12 am
Viewing 15 posts - 24,106 through 24,120 (of 49,552 total)