Viewing 15 posts - 61 through 75 (of 433 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
"More Green More Oxygen !! Plant a tree today"
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.
"More Green More Oxygen !! Plant a tree today"
September 21, 2011 at 3:58 am
Never give admin rights to DEV team.
"More Green More Oxygen !! Plant a tree today"
September 21, 2011 at 3:56 am
I have set it through RESPONSE but it does not work for me
"More Green More Oxygen !! Plant a tree today"
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...
"More Green More Oxygen !! Plant a tree today"
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...
"More Green More Oxygen !! Plant a tree today"
May 26, 2011 at 4:36 am
Permission on the DB server D drive backup folder.
"More Green More Oxygen !! Plant a tree today"
May 26, 2011 at 4:27 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...
"More Green More Oxygen !! Plant a tree today"
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...
"More Green More Oxygen !! Plant a tree today"
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...
"More Green More Oxygen !! Plant a tree today"
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...
"More Green More Oxygen !! Plant a tree today"
May 16, 2011 at 9:54 pm
Thanks did helped me.
"More Green More Oxygen !! Plant a tree today"
May 16, 2011 at 3:30 am
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 :...
"More Green More Oxygen !! Plant a tree today"
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...
"More Green More Oxygen !! Plant a tree today"
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...
"More Green More Oxygen !! Plant a tree today"
May 13, 2011 at 12:28 am
Viewing 15 posts - 61 through 75 (of 433 total)