Viewing 15 posts - 4,546 through 4,560 (of 9,250 total)
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
It's not clear what your issue is. If you used the GUI to initialise LS why are you trying to restore the secondary database?
Detail the exact steps you have taken...
November 28, 2012 at 1:31 am
Viewing 15 posts - 4,546 through 4,560 (of 9,250 total)