Viewing 15 posts - 61 through 75 (of 107 total)
Hi Suri,
To this this;
1. Delete the subscription (guessing it won't let you detach the db until you do so)
2. Detach the db
3. Move the db accordingly
4. Recreate the subscription (might...
October 18, 2011 at 3:57 am
Sharepoint integration modes gives you additional functionality over native, inc. document management and security permissions to control access to reports, etc.
Integration mode can give you 'one-stop-shop' for all your info,...
October 14, 2011 at 4:49 am
OP has stated that he already tried Maintenance Plans which has a subset of SSIS tasks specific to database maintenance e.g. backup, index re-build etc.
My point was that you...
October 13, 2011 at 8:24 am
I don't think we'd be able to persuade management to go for another 3rd party clustering solution after the Polyserve fiasco!
We've decided to swap it out for Windows 2008...
October 13, 2011 at 6:42 am
I would go a step further and not only have source control but also a change management process to ensure any code going into live has been fully tested when...
October 13, 2011 at 6:20 am
Hi Akkare,
You're going to have to break the mirroring, restore the db as 'Symantran' (in recovery) before resuming mirroring as you normally would do.
Cheers
Vultar
October 13, 2011 at 5:55 am
How about creating a share on the 2nd server and backing upto that location ?
You could also look into creating an SSIS package.
Cheers
Vultar
October 13, 2011 at 5:37 am
I'd have a look at Quest Spotlight. This has a 'traffic light' system to view your SQL estate and the ability to drill down into a server to look at...
October 8, 2011 at 2:41 am
Hi Miranda,
Good to hear your enjoying your SQL server experience 🙂
You can have 1 default instance, but multiple named instances on a single machine and you should install the oldest...
October 7, 2011 at 5:16 am
Hello Surii,
Unfortunately I don't know where to go with this because I would at least expect some errors to be showing somewhere.
I'm interested to see if there's a fix so...
October 6, 2011 at 1:53 pm
Strange, I would expect at least one of the replication agents to be showing an error if the tracer tokens not reaching its destination.
What about the sql error logs...
October 6, 2011 at 1:33 pm
Hi Surii,
If you go to replication monitor, click on the 'warnings and agents' tab, what is the status of the snapshot and log reader agents at the bottom of the...
October 6, 2011 at 1:05 pm
Hi Surii,
Sorry, my mistake.. it was the publication I was meant to refer to, not the article!
In the replication monitor, if you click on the 'warnings and agents' tab, which...
October 6, 2011 at 2:03 am
What happens when you put a tracer token into one of the articles which isn't working ?
Vultar
October 5, 2011 at 9:35 am
I think you need 2 log reader agent profiles to do this, so you'll need to create a new 1.. 1 specifying ServerA in DistributionCentre2 as a failover partner, and...
October 5, 2011 at 9:06 am
Viewing 15 posts - 61 through 75 (of 107 total)