Viewing 15 posts - 4,951 through 4,965 (of 49,552 total)
Just don't set the DB to simple recovery model in the process.
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
August 24, 2015 at 2:49 am
Steve Jones - SSC Editor (8/21/2015)
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
August 21, 2015 at 8:05 am
Phil Parkin (8/21/2015)
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
August 21, 2015 at 5:32 am
podmate (8/20/2015)
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
August 21, 2015 at 3:21 am
Yes. It's a common reason for error 32.
Fix your virus checker according to MS recommendations: https://support.microsoft.com/en-us/kb/309422
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
August 21, 2015 at 3:07 am
What you probably want to read is this: http://www.sqlservercentral.com/articles/Administration/64582/
Before you do anything, find out what the recovery requirements are for the databases. If drives fail, is restoring to the previous...
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
August 21, 2015 at 2:55 am
Why? He's not deleting the log.
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
August 21, 2015 at 2:51 am
Operating system error 32 is "File in use by another process". It's not permission-related.
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
August 20, 2015 at 1:49 pm
Eric M Russell (8/20/2015)
The two combined should sum near the same with two identical plans
The logical reads should be the same with identical plans. The physical reads may not.
It's...
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
August 20, 2015 at 1:46 pm
Which is missing any useful information. 🙁
Check that the query window where you ran the SELECT from sys.databases is pointing to the correct server. There's no reason I can think...
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
August 20, 2015 at 8:03 am
Someone who's more familiar with mirroring please have a look here: http://www.sqlservercentral.com/Forums/Topic1713336-2799-1.aspx
Does not look right to me that a mirrored DB isn't in the system views (I wonder if she's...
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
August 20, 2015 at 7:46 am
Also confirm that no one's done anything stupid, like granting CONTROL SERVER to public or assigning the sysadmin role to <DOMAIN>\Users (seen both before)
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
August 20, 2015 at 7:39 am
Huh?
No, once you fail over the mirror is active and the DB is online.
You have mirroring implemented at the moment, the principle on one instance, the mirror on another?...
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
August 20, 2015 at 7:37 am
Eric M Russell (8/20/2015)
They can even drop you as a SYSADMIN and declare themselves God if they want.
Now there's something for someone's sig..
DECLARE @Myself CHAR(3) = 'GOD';
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
August 20, 2015 at 7:26 am
Does the database xyz exist?
What does this return?
select name from sys.databases
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
August 20, 2015 at 7:24 am
Viewing 15 posts - 4,951 through 4,965 (of 49,552 total)