Viewing 15 posts - 12,601 through 12,615 (of 49,552 total)
The SQL Server service account (the account that SQL server is running under) needs full control of all folders where databases exist.
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
June 24, 2013 at 2:19 am
Try RESTORE ... WITH CONTINUE_AFTER_ERROR on SQL 2005 or above
It's highly unlikely to work, but you can try. If it doesn't work, then the backup is useless.
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
June 23, 2013 at 5:30 am
Vedran Kesegic (6/21/2013)
Comparing that to Gail's 15 minute walk from home to test center, makes me jealous 🙂
15 minute drive, and that test center no longer exists, so the next...
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
June 23, 2013 at 4:11 am
Please post new questions in a new thread and include error messages in text (you can copy from any error dialog in SSMS)
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
June 23, 2013 at 4:06 am
Brandie Tarvin (6/20/2013)
Gail Shaw's name all over the...
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
June 22, 2013 at 3:27 am
Not possible. The system date is the Windows system date. This shouldn't be changed as it can cause problems with Kerberos tickets.
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
June 22, 2013 at 3:20 am
Don't understand the question
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
June 21, 2013 at 4:22 pm
In multiple log records that describe the change and how to undo it.
What are you trying to discover or fix?
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
June 21, 2013 at 4:21 pm
DiverKas (6/21/2013)
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
June 21, 2013 at 1:53 pm
To be honest, I don't have time right now, or for a couple of weeks.
Go hit my blog and look for a post on user-defined functions, IO statistics and the...
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
June 21, 2013 at 1:49 pm
Why? What is that total number going to tell you?
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
June 21, 2013 at 6:40 am
Maybe, maybe not. Depends on the tables, the data patterns and the queries that run.
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
June 21, 2013 at 4:35 am
DKG-967908 (6/21/2013)
why don’t you recycle SQL error log by exec sp_cycle_errorlog.
It's not that his error log is growing, it's that SQL is stack dumping and writing large stack dumps into...
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
June 21, 2013 at 4:35 am
Nothing to do with any relationships between NETWORK and SYSTEM. The service account that SQL Server is running under does not have permission to that folder. Check what account SQL...
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
June 21, 2013 at 4:11 am
Create a trace (or look in the default trace) for security events. I can't remember offhand which event it is, Books Online will have details.
p.s. Why are you using the...
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
June 21, 2013 at 3:35 am
Viewing 15 posts - 12,601 through 12,615 (of 49,552 total)