Viewing 15 posts - 946 through 960 (of 991 total)
This is terrible advice. Most suspect databases WILL NOT reattach successfully.
Cristo - did the database/log run out of space? Why did it go suspect in the first place? You may...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
September 12, 2007 at 6:42 pm
Can you run DBCC CHECKDB against master and see if there are any corruptions?
What happens if you manually run 'select * from master..sysdatabases'?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
September 12, 2007 at 6:39 pm
Looks like you've got a controller issue - some of the pages have been wiped out with random garbage and one oset of pages has been overwritten by the next...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
September 12, 2007 at 6:37 pm
"I'm surprised you ran "allow data loss". Paul Randal, Storage Engine Lead for SS2K5 and SS2K spoke at TechEd. He said don't run it. Ever, ever, ever, ever."
Not quite -...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
September 12, 2007 at 6:33 pm
Sounds like your Express instance is not configured to accept remote connections (default setting for an Express instance). To change it, follow the instructions at http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
Hope this helps
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
May 21, 2007 at 2:41 pm
The extra 14 bytes is only needed for records in heap pages. Here's why - heap records do not have keys, by definition, so the only way to reference them...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
June 25, 2006 at 8:50 pm
And as you can see, geekiness runs in my family!
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
June 24, 2006 at 12:42 pm
Here's a reply I'd given Georges in response to a PM.
Hi Georges,
Yes, you probably need to analyze the queries being created to see whether inefficient access paths are being chosen....
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
June 7, 2006 at 10:17 am
This indicates that your backup is corrupt in some way. Can you try the restore command manually and see if there are any more errors? Can you also post the...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
January 5, 2006 at 10:54 am
The answer is yes. A CHECKDB summary of errors found/fixed is always put into the errorlog and if any errors are found, they will be logged in the Windows event...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
January 5, 2006 at 10:51 am
Not really. Which version of SQL Server are you running?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
December 19, 2005 at 2:58 pm
ok - so if the table schemas are exactly the same and the data is still readable in the source database then the problem occured during the copy process or...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
December 16, 2005 at 10:33 am
Were you running shrink or do you have auto-shrink turned on? Looks like you've hit a bug in shrink - see here for details and the fix http://support.microsoft.com/kb/811205
If you are...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
December 16, 2005 at 10:12 am
There are two issues around blocking in SP4. One's a real bug, the other isn't.
The first one is a bug in the lock manager that manifests during DBCC INDEXDEFRAG. The...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
December 16, 2005 at 9:58 am
So was the data perfectly readable in the source database? Using what mechanism?
How did you copy it?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
December 15, 2005 at 6:18 pm
Viewing 15 posts - 946 through 960 (of 991 total)