Viewing 15 posts - 42,496 through 42,510 (of 49,552 total)
Any errors in the error log when you try to use the DB?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 8, 2008 at 8:21 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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 ?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 8, 2008 at 5:29 am
Shark Energy (12/8/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 8, 2008 at 4:59 am
herbiechin (12/8/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 8, 2008 at 4:16 am
Select count(*) from sys.tables
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 8, 2008 at 4:08 am
Yup, that's fine.
Were you trying to grow the data file when those messages appeared?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 8, 2008 at 2:37 am
Viewing 15 posts - 42,496 through 42,510 (of 49,552 total)