Viewing 15 posts - 91 through 105 (of 1,536 total)
I've run into a bug before where the LS Restore happens but for some reason does not get accurately represented in any built in reports or functions. Your best bet...
June 4, 2012 at 2:58 pm
Don't use the IP address, use the server name (the @@servername value). Specifying an instance doesn't make a difference here.
April 10, 2012 at 3:52 pm
A static IP isn't required for a subscriber (although it's best to have one if possible).
I only mention using SSMS from the publisher as it's a great way to test...
April 9, 2012 at 10:03 am
If you log on to the publisher are you able to successfully make a connection to the subscriber using SSMS?
April 9, 2012 at 9:49 am
There's a couple of things worth checking, firstly that you aren't trying to connect to a named instance (bear in mind that even named instances can be forced into listening...
April 9, 2012 at 9:38 am
I think that your best bet for checking the AD account status would be to setup an ADSI linked server and query the account there. That way you'll be able...
April 5, 2012 at 10:57 am
First steps, check to see if the service is running or not.
March 16, 2012 at 3:54 pm
Bear in mind that if you have transaction log backups that run every 15 minutes, copy jobs that run every 15 minutes and restore jobs that run every 15 minutes...
March 16, 2012 at 12:04 pm
By removing a column from replication itself you are fundamentally changing the replication article. What has to happen is that a new article will need to be created, individual columns...
March 16, 2012 at 9:57 am
The account has full access to the local server (which is a security concern) however it has no access outside of that server meaning that you cannot hit the share...
March 15, 2012 at 12:13 pm
That will be your cluster name. When you created your cluster you would have given it a name. This then becomes a computer object in AD. You can then grant...
March 15, 2012 at 10:33 am
shashi_1409 (3/14/2012)
March 14, 2012 at 10:16 pm
It's always worth remembering that SQL runs under the context of it's service accounts (unless you setup specific proxies).
This means if you are executing a command directly it will run...
March 14, 2012 at 3:39 pm
You'll also need to have a virtual name for the cluster itself (if you've not taken that into account)
March 13, 2012 at 10:47 am
Viewing 15 posts - 91 through 105 (of 1,536 total)