Viewing 15 posts - 7,066 through 7,080 (of 49,552 total)
Because the updates, inserts and deletes were in the workload that you're replaying? Whatever's in the workload will get run against the target server if you're replaying 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 9, 2014 at 1:15 am
The instance will be restarted multiple times and, during the installation when it is running it'll be in administrator-only mode.
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 9, 2014 at 1:13 am
You need to check that the SQL instance is running and accessible, because the error is saying that it's not.
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, 2014 at 6:00 am
Errrr.....
NOT EXISTS or NOT IN, if I've understood what you're asking.
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, 2014 at 5:51 am
From that error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name...
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, 2014 at 5:22 am
Not possible.
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, 2014 at 5:06 am
If you've lost the log backups before 2pm (and it doesn't matter how many are lost, one is enough) and you don't have a differential or full backup taken after...
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, 2014 at 1:35 am
mike 57299 (12/7/2014)
What I want to do is set recovery to simple - reset log to 30GB - set recovery to full. Will this work?
Work to do what?
Break your...
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, 2014 at 1:34 am
John Mitchell-245523 (12/5/2014)
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 5, 2014 at 7:19 am
You set the database to single user and someone else got the single allowed connection before the log backup did. The connection you ran that from wasn't using that database...
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 5, 2014 at 6:41 am
FCB::Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf for file number 1. OS error: 32(The process cannot access the file because it is being used by another process.).
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
December 5, 2014 at 5:53 am
Since you've posted no information, none of the errors that the article showed you how to find, no idea.
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 5, 2014 at 3:44 am
At this point I'm recommending that clients on 2005/2008/2008 R2 upgrade to SQL 2014 and for clients on SQL 2012 to stay put unless there's a compelling feature they absolutely...
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 5, 2014 at 2:37 am
And crisis, panic, run around screaming, the EF-based app is slow.
600MB database, generating 5GB of trace data in 1 hour....
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 5, 2014 at 2:35 am
Query hint overrides server maxdop
Resource governor overrides server maxdop
Query hint does not override Resource governor
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 5, 2014 at 2:25 am
Viewing 15 posts - 7,066 through 7,080 (of 49,552 total)