Viewing 15 posts - 61 through 75 (of 434 total)
YOu need to analyze the deadlock graph which will be in the error log. Find out the victim if possible attach the graph here, we will help you out
September 21, 2011 at 4:04 am
You will not loose data as the data will sycn on mirrored server periodically, only concern during DR you might loose data.
September 21, 2011 at 3:58 am
Never give admin rights to DEV team.
September 21, 2011 at 3:56 am
I have set it through RESPONSE but it does not work for me
August 29, 2011 at 8:29 am
Replication is used to replicate the data to diff location or instance and standby solution is for failover if Primay is not available. Generally standby ( using mirroring or Log...
August 23, 2011 at 10:28 pm
Are you the DBA? Generally DBA's have all the permission needed. So you can check if SQL Server service account have permission on the Remote server.
Your SQL authentication account...
May 26, 2011 at 4:36 am
Check if SQL Service account have permission to the backup folder, also if the user account you have logged in have the permission. As you specified you are conencting from...
May 26, 2011 at 4:20 am
I had the similar issue on our PROD environment, by finding the culprit SPs and tunning it had helped us to manage the TEMP DB space.
Hence everything depends on...
May 26, 2011 at 4:13 am
There might be two issues
One) With the mail server, may be too many mails hits the mail server, you can check with the IT team.
Two) Why SQL Server...
May 26, 2011 at 1:32 am
How are you upgrading? Could you please share the syntax? do u have all admin rights ?
Upgrading SQL Server will throws lots of issue, We followed the simple method of...
May 16, 2011 at 9:54 pm
Thats a good one.
Yes it is very true cluster failover is the SQL service fail over, hence you will receive this error.
One thing I want to know :...
May 16, 2011 at 3:24 am
Please correct me so my understading is ;
I have two nodes in which I should have two separate instance in different file group sharing the same SAN, with one...
May 15, 2011 at 10:10 pm
Quite surpirse to find Alter database command for log shipping standby databases.
In case you have added new logins in the primary databases then either use SSIS or script to...
May 13, 2011 at 12:28 am
Viewing 15 posts - 61 through 75 (of 434 total)