Viewing 15 posts - 19,441 through 19,455 (of 49,552 total)
Yes, the process of making the mirror server the primary in the case of a disaster is called 'failing over the principal', which is what the section I referred 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
March 31, 2012 at 8:31 am
farrukh635 (3/31/2012)
One of our company client has already configured the mirroring but there is no witness server so i want to confirm if the principle server goes down or damaged...
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
March 31, 2012 at 6:26 am
If there is no witness, you will not get automatic failover, you'll have to do any failovers manually. Have a look at the database mirroring section in Books Online, specifically...
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
March 31, 2012 at 6:25 am
No particular considerations. Just set the drive up as you would if it was going to contain a normal database file.
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
March 31, 2012 at 6:23 am
You mean a primary key enforced by a nonclustered index? Yes, it's possible. See Books OnLine (ALTER TABLE) for the detailed syntax.
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
March 31, 2012 at 6:22 am
I read the end of that and I am not getting involved...
Initial gut feel - improper transaction management (leaves transactions open) combined with connection pooling. Connection gets discarded from pool...
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
March 30, 2012 at 4:03 pm
sqlfriends (3/30/2012)
So the first statement is to insure the constraints can be created.
The second one enables the foreign key and will check both exisiting and new future data.
If 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
March 30, 2012 at 3:49 pm
sqlfriends (3/30/2012)
Sorry, I still don't understand it.The first is to add constraints without checking existing data.
What does the second do, check constraint??
Why first one not check, the second check...
As per...
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
March 30, 2012 at 2:47 pm
From Books Online:
{ CHECK | NOCHECK } CONSTRAINT
Specifies that constraint_name is enabled or disabled. This option can only be used with FOREIGN KEY and CHECK constraints. When NOCHECK is...
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
March 30, 2012 at 2:37 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No further replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1276016-1633-1.aspx
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
March 30, 2012 at 2:34 pm
No, the space will be automatically made reusable once you switch to simple recovery. Did you read the article?
If you're talking about shrinking, first thing you need to do is...
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
March 30, 2012 at 2:32 pm
Please read through this - Managing Transaction Logs[/url]
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
March 30, 2012 at 1:50 pm
Lynn Pettis (3/30/2012)
Yes, it is. BACKUP LOG <database_name> WITH NORECOVERY.
When the data file is damaged or missing, the backup log must have the NO_Truncate option, or it will fail...
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
March 30, 2012 at 1:15 pm
dan-572483 (3/30/2012)
So a tail of the log backup does not require the data file to exist. Thanks!
Provided the DB is in full recovery or is in bulk-logged recovery and...
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
March 30, 2012 at 1:11 pm
USE [MMG-Events];
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
March 30, 2012 at 10:01 am
Viewing 15 posts - 19,441 through 19,455 (of 49,552 total)