Viewing 15 posts - 42,511 through 42,525 (of 49,566 total)
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...
December 8, 2008 at 7:47 am
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...
December 8, 2008 at 7:40 am
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...
December 8, 2008 at 7:25 am
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...
December 8, 2008 at 7:20 am
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...
December 8, 2008 at 6:52 am
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...
December 8, 2008 at 6:18 am
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 ?
December 8, 2008 at 5:40 am
Shark Energy (12/8/2008)
We are talking full AND log backups off onto their own array?
You asked for best practice 😀
All the backups can go onto a single array. For Very large...
December 8, 2008 at 5:29 am
Shark Energy (12/8/2008)
December 8, 2008 at 4:59 am
herbiechin (12/8/2008)
December 8, 2008 at 4:16 am
Select count(*) from sys.tables
December 8, 2008 at 4:14 am
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...
December 8, 2008 at 4:08 am
Yup, that's fine.
Were you trying to grow the data file when those messages appeared?
December 8, 2008 at 4:06 am
mohd.imtiaz (12/8/2008)
EACH GROUPING HAS DIFFERENT COLUMN IN IT
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...
December 8, 2008 at 2:37 am
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...
December 8, 2008 at 2:22 am
Viewing 15 posts - 42,511 through 42,525 (of 49,566 total)