Viewing 15 posts - 391 through 405 (of 1,366 total)
Whats your Server Configuration and memory values
December 9, 2015 at 5:05 am
As Steve mentioned Powershell Or you can use SQLCMD. Among these two PS is better.
December 9, 2015 at 5:03 am
Perry Whittle (12/8/2015)
Ratheesh.K.Nair (12/6/2015)
We have a 2 node cluster installation with 3 instances. I am able to do DAC locally to all these instances. I have enabled 'Remote Administrator...
December 9, 2015 at 4:59 am
Robert vd Berg (12/7/2015)
December 9, 2015 at 4:14 am
Grant Fritchey (12/7/2015)
Take a look at the book "Troubleshooting for the Accidental DBA" That will give you plenty of knowledge to do this. Plus, it's free to download.
Thanks Grant.
December 9, 2015 at 4:12 am
johnwalker10 (12/6/2015)
Check out the following link https://technet.microsoft.com/en-us/library/cc781394(v=ws.10).aspx
Thanks John
December 9, 2015 at 4:12 am
anthony.green (11/24/2015)
Best practice I always follow is each service has its own service account.
Thanks Anthony.. You are the man.
November 24, 2015 at 4:52 am
Thanks Anthony, Phil and John.
New to me that CDC and CT will help update data between two tables. Thanks Again Phil.
November 18, 2015 at 3:27 am
Phil Parkin (11/17/2015)
Ratheesh.K.Nair (11/17/2015)
Hi Experts,Is there anyway to sync few tables of two live databases which are hosted in different servers?
TIA
Is that a two-way sync?
Thanks Phil,
Yes it ha to be...
November 17, 2015 at 3:35 am
Are you able to connect to instance without any issue??
Try running SSMS as administrator. Also check what error you get while using query sp_attach_db.
November 9, 2015 at 3:44 am
anthony.green (11/9/2015)
My first step would be to find the sproc in question and check that out. If that's...
November 9, 2015 at 3:33 am
Viewing 15 posts - 391 through 405 (of 1,366 total)