Viewing 15 posts - 856 through 870 (of 991 total)
Looks like the file header for your .mdf file is corrupt. There's no way around that except to restore from your backups. Product Support will advise you of the same...
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
November 7, 2007 at 10:12 am
syed muhammad naveed (10/30/2007)
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
October 30, 2007 at 12:48 pm
Jim Dillon (10/29/2007)
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
October 29, 2007 at 11:49 am
syed muhammad naveed (10/29/2007)
just apply this techenique
right click on your corrupted LDF file and mar read only option
and then attached it again inshallah 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
October 29, 2007 at 9:01 am
syed muhammad naveed (10/29/2007)
i have one techenique for you just apply may be your problems will resolve.
i am sure that you still have LDF and MDF file in your...
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
October 29, 2007 at 8:59 am
Steve pinged me - the only way to do this is as you have above CREATE DATABASE ... FOR ATTACH.
If none of the files have changed locations from when...
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
October 25, 2007 at 5:22 pm
I almost replied to his comment this morning - seems there's been a rash of him posting redundant/irrelevant info on threads.
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
October 24, 2007 at 1:47 pm
If you're doing a lot of writes then RAID 5 is not the way to go - you'd be better off with RAID 10. See this whitepaper on Physical Database...
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
October 24, 2007 at 11:56 am
CJR (10/24/2007)
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
October 24, 2007 at 9:04 am
VAIYDEYANATHAN.V.S (10/24/2007)
Kindly consider on the Isolation Levels and implement the same
Please stop posting irrelevant info.
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
October 24, 2007 at 9:02 am
err - again, like the previous thread you replied to - not really any more useful info here.
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
October 24, 2007 at 12:07 am
That's not relevant to the discussion here - posting a link to a BOL topic saying how to run shrink isn't going to help figure out the errors posted here.
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
October 24, 2007 at 12:04 am
You can't do that. Here's a quote from Books Online for ALTER TABLE ALTER COLUMN (with my bolding)
ALTER COLUMN
Specifies that the named column is to be changed or altered....
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
October 23, 2007 at 11:42 pm
Standard and Enterprise both support the OS maximum.
I'm guessing you're running on Windows 2003 Server? If so, the OS only allocates AWE memory to SQL Server on demand - different...
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
October 23, 2007 at 11:35 pm
One other thing - is the system *really* busy while the shirnk is going on? Are the disk queue lengths really long? This could be an IO that never completes...
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
October 23, 2007 at 11:26 pm
Viewing 15 posts - 856 through 870 (of 991 total)