Sure. That's how I used to always read my log files.

Open in ultra edit and set the editor to reload changes any time it got focus.

Sergei Zarembo (12/8/2008)

---

--can you try this: [not tested]

;WITH MyCTE as (SELECT TOP 1 c.ID, MRN

...

I generally find it much easier and faster to open the error log in a good text editor (ultraedit, notepad++, etc)

Not really.

Any errors in the error log when you try to use the DB?

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