Viewing 15 posts - 556 through 570 (of 1,179 total)
Thank you, for your overwhelming response.
Cheers!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 26, 2014 at 11:14 pm
Are you keeping 2nd server idle? i.e. no read/wirte on the 2nd server and need High Availability than you can think of Database Mirroring. Also DB mirroring give you flexibility...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 17, 2014 at 3:32 am
Yes it is OK if you do not have pager. You can configure only e-mail. Refer following link for detail troubleshooting.
http://technet.microsoft.com/en-us/library/ms188663(v=sql.105).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 17, 2014 at 3:20 am
No easy way! But yes, you can do it programatically by pulling data from system tables. Create stored procedure to send mail and add stored procedure to the additional step...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 16, 2014 at 11:22 pm
Nice one.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 16, 2014 at 11:17 pm
Thank you, Steve for small correction.
Appreciate everyone for comments and sharing experience which helps to enhance knowledge and understanding of new technology.
Regards,
FM
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 15, 2014 at 11:01 pm
Good One!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 15, 2014 at 10:51 pm
Hello Koen,
Thank you for sharing additional information.
Best regards,
FM
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 14, 2014 at 12:21 am
check and verify that sql server agent services are up and running. Also check if any error is recorded in log.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 13, 2014 at 2:42 am
Good One!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 2, 2014 at 4:02 am
Hi Mohamed,
If what you said is correct than we are able to detach the database by changing the compatibility and attached to the lower version. But this is not possible.
Refer...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 31, 2013 at 3:14 am
Do you mean bi-directional?
Refer following link:
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 23, 2013 at 11:23 pm
Usually DBCC CHECKDB should be executed during off-peak hours. What is type of server? i.e. prod, dev, test? what is the size of database? Command blocking spid is same as...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 23, 2013 at 4:52 am
Depends on the various business requirement replication can be set up between Publisher and subscriber. It can also support heterogeneous environment.
Refer following BOL topic for further detail and understanding. It...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 19, 2013 at 1:42 am
Can you please share diagram of physical architecture so that it will be clear what you exactly looking for?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 18, 2013 at 5:23 am
Viewing 15 posts - 556 through 570 (of 1,179 total)