No maintenance window? Weekends?

You don't have to stop SQL. Once the Alter Database has been run, you can take that DB offline, move the files and then bring it back...

One other thing to note is that shrinking any tempDB files while TempDB is in use may result in corruption.

http://support.microsoft.com/kb/307487 (see right at the bottom, the section "Effects of Execution...

Operating system error 5 (which is what you're getting) is access denied. Means that for some reason the SQL service account doesn't have access to those files

Please check what account...

You an do an ALTER DATABASE ... MODIFY FILE ... MOVE, but that still requires the SQL to be stopped or the DB taken offline and the files moved...

Can you post the entire error log, from server startup to after the other DB's come online?

If all the files are there and readable, perhaps try restarting SQL again. It...

Have you changed any of the SQL service accounts recently? Done anything to the NTFS permissions?

Did the DB go suspect when the server started? If not, what led up to...

Is the E drive present and readable?

Are the files that SQL's looking for (GE35test.mdf, GE35test_1.mdf, ... GE35test_6.mdf) present in the directory E:\HR1 ?

You asked for best practice 😀

All the backups can go onto a single array. For Very large...

Shark Energy (12/8/2008)

---

My question now is - I have a RAID 5 10 disk for Data and Tempdb. I have a 2 disk RAID 1 for logs. Do I stick...

herbiechin (12/8/2008)

---

It appears the action completes, but I get a list of errors. I have ran a checkdb (on the safe side) on the entire database and it shows...

Select count(*) from sys.tables

Please don't type in all caps. It's the online equivalent of shouting at someone.

From what I can see from the exec plan, you have no indexes at all on a...

Yup, that's fine.

Were you trying to grow the data file when those messages appeared?

No need to shout.

Since there's no way that the resultsets can overlap (there's a literal string that's different in each one), use UNION...

My guess is that you have autogrow enabled, one of more files grew and completely overloaded the IO system.

Either set smaller autogrow increments or (preferably) monitor the free space in...