Viewing 15 posts - 4,546 through 4,560 (of 9,253 total)
either check the status in SQL Server management studio or query sys.database_mirroring
November 29, 2012 at 6:28 am
raotor (11/28/2012)
Perry Whittle (11/28/2012)
what is the error you are receiving?
There's no error as such.
When I right-click on the database, click Tasks, click Restore and then select Database the list of...
November 28, 2012 at 1:17 pm
Jpotucek (11/28/2012)
currently, all Cluster resources (The Quorum and both sets of...
November 28, 2012 at 12:07 pm
what is the error you are receiving?
November 28, 2012 at 12:04 pm
dan-572483 (11/28/2012)
Interesting... So a 2-Node failover cluster can host multiple default instances (using separate network names & IPs & drives).
No, it can't and that's not what I...
November 28, 2012 at 11:58 am
Ensure you present any shared storage to the second node and then open the sql server installer and select the option "Add node to a SQL Server failover cluster" 😉
November 28, 2012 at 9:52 am
I'm already working on a guide for sql server 2012, windows 2012 on ESX5.1i
November 28, 2012 at 9:22 am
BigSam (11/28/2012)
A. When SQL was in a failed state on Node A I tried to bring it online from SQL Configuration Manager
Incorrect, bring the resources online manually from failover cluster...
November 28, 2012 at 9:17 am
raotor (11/28/2012)
2. Why ever destroy the existing chain by performing a second full backup other than for purely space or management reasons?
Full backups DO reset the Differential Base LSN, so...
November 28, 2012 at 5:22 am
itis4junk (11/27/2012)
I'll request the database to be upgraded.Thank you,
Khanh Pham
Theres a vast difference in the licencing costs from Std to Ent, if all you want is compression then Redgate's SQLBackup...
November 28, 2012 at 4:17 am
For the instance to start it needs to have a master db present, i use the tact above and then make sure to restore a full system backup set once...
November 28, 2012 at 4:11 am
SQLSACT (11/28/2012)
GilaMonster (11/28/2012)
Yes, it is necessary. Rebuild the system databases, start SQL, restore the backups of the system DBs.
Could this possibly work:
>> Restore the Master database to another SQL Instance
>>...
November 28, 2012 at 2:37 am
APA0876 (11/27/2012)
What will be the default instance name on a SQL Server failover cluster (2 nodes).
I have an active/active sql server failover cluster and I want to install a default...
November 28, 2012 at 1:48 am
nhphuong76 (11/28/2012)
I want to know what the transactions executed ?
You'll commonly see this in the log if an admin opens the SQL Server instance properties page (right click the instance...
November 28, 2012 at 1:39 am
Minaz Amin (11/27/2012)
If yes, how the aaplication communicate to it?
If you're using ADO.NET or SQL Native client there is a "Failover Partner" option specifically for database mirroring sessions
Minaz Amin...
November 28, 2012 at 1:36 am
Viewing 15 posts - 4,546 through 4,560 (of 9,253 total)