What do you mean 'gone bad'?

It's possible to do an in-place upgrade of a SQL2000 instance. It's also possible to attach SQL 2000 databases to a 2005 instance and they...

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...

syed muhammad naveed (10/30/2007)

---

actually i m sharing you my personal experience you know the database is totally depend on the operating system if the problem occur in OS then database...

Jim Dillon (10/29/2007)

---

You should be able to do both full and transactional backups with the database still remaining online and available. If you move to SQL Server 2005 Enterprise,...

syed muhammad naveed (10/29/2007)

---

ok dear dont worry

just apply this techenique

right click on your corrupted LDF file and mar read only option

and then attached it again inshallah it...

syed muhammad naveed (10/29/2007)

---

dear Eric

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...

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...

I almost replied to his comment this morning - seems there's been a rash of him posting redundant/irrelevant info on threads.

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...

CJR (10/24/2007)

---

Thanks, I will read up on that. Some additional info for now. Appears that maybe there is a conflict between DBCC, LAZY WRITER, and CHECKPOINT. I was watching sysprocesses...

Please stop posting irrelevant info.

err - again, like the previous thread you replied to - not really any more useful info here.

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.

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....

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...