Viewing 12 posts - 1 through 12 (of 12 total)
We can set up Mirroring and log shipping on the same database. Below is the link that explains how it works.
January 9, 2013 at 6:43 am
Just to add a check point
Once the cluster node is built and added to the MSCS cluster. Please validate the cluster setup.
After installing SQL Server, Test the cluster by performing...
January 8, 2013 at 10:17 am
To clear your doubt, Whenever SQL Server is upgraded to a higher version it means that the Database Engine gets upgraded to new version.
From the user point of view...
January 6, 2013 at 9:50 am
Check if SQL Services are up and running post upgrade
check if you were able to login to the SQL Server using SA account
If the upgrade is successful then see if...
January 5, 2013 at 11:16 am
In Active Passive clustering, Instance1 would be active on node1 and on node2 SQl Services will be in stopped state. When ever a failover happens the SQl resource group will...
January 5, 2013 at 11:10 am
Have you tried re-cycling SQL Services instead of System Reboot. This would differentiate if the problem is at the instance level or at the server level.
January 3, 2013 at 6:12 pm
You can use the sys.dm_os_memory_clerks dynamic management view (DMV) to get detailed information about memory allocation by the server components in SQL Server 2005 and 2008. Some of the...
January 2, 2013 at 10:30 pm
To simplify the fix for you
What is the backup strategy you have implemented for these databases?
You need to have log backups at regular intervals inorder to manage your transaction log...
January 2, 2013 at 10:13 pm
Attaching and restoring databases from one server instance to another are common tasks executed by a DBA.If we move our database to another SQL Server instance through any process, the...
January 2, 2013 at 10:04 pm
Check Windows EventLog to figure out who has connected. Probably this might give you a clue.
October 16, 2012 at 9:12 pm
Can u give a small example of which type of data should be removed.
It would be better if u give sample data for both the Primary table and Reference table. And an...
October 18, 2005 at 5:47 am
Thanks, for the information provided. but it will be a great help if anyone could send a list of patches released and what patches are included in the service pack
October 18, 2005 at 5:31 am