Viewing 15 posts - 27,031 through 27,045 (of 49,552 total)
Jeff Moden (3/28/2011)
Gianluca Sartori (3/28/2011)
GilaMonster (3/28/2011)
Not trying to start any bashing or pile-ons, but this has to rate high on the list of most useless replies: http://www.sqlservercentral.com/Forums/FindPost1084783.aspx
Sounds like "OK, just...
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
March 28, 2011 at 7:31 am
That's not an error. It's just part of the output of the script, which probably had a reconfigure in it right after that.
Did the script complete successfully? If not, look...
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
March 28, 2011 at 6:44 am
Try alter user first.
ALTER USER ctuser WITH LOGIN = ctuser
That should fix the orphaned login without the need to go through all sorts of convoluted steps.
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
March 28, 2011 at 6:02 am
Not trying to start any bashing or pile-ons, but this has to rate high on the list of most useless replies: http://www.sqlservercentral.com/Forums/FindPost1084783.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
March 28, 2011 at 5:14 am
Sachin Nandanwar (3/28/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
March 28, 2011 at 5:11 am
Then you are going to have to rebuild msdb and lose any jobs, any DTS or SSIS packages, any backup history.
http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/06/619304.aspx
Is there a DBA there who can help 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
March 28, 2011 at 4:08 am
It means exactly what I said. Checkpoint writes the changed pages to disk, it does not remove the data page from memory.
Some transaction has run, it has required SQL to...
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
March 28, 2011 at 3:42 am
Um, you restore from a database backup, not from the database itself.
You do have backups, don't 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
March 28, 2011 at 3:37 am
Sachin Nandanwar (3/28/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
March 28, 2011 at 3:12 am
Don't understand what you're asking.
Get your backup of MSDB and restore 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
March 28, 2011 at 3:04 am
Sachin Nandanwar (3/28/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
March 28, 2011 at 2:56 am
And my answer was that they do not share service packs, no more than 2005 and 2008 share service packs.
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
March 28, 2011 at 2:41 am
Not necessarily. They could be sent before, they could be sent after, it really doesn't matter.
http://sqlinthewild.co.za/index.php/2008/12/05/a-new-sql-myth/
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
March 28, 2011 at 2:40 am
Wow, was it really necessary to use that font size? Please edit and reduce that font to something readable.
Restore from your last good backup of MSDB.
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
March 28, 2011 at 2:31 am
http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/
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
March 28, 2011 at 2:30 am
Viewing 15 posts - 27,031 through 27,045 (of 49,552 total)