Viewing 15 posts - 541 through 555 (of 1,790 total)
Shinoj Ramanathan (8/9/2010)
I need to restart my distributor. Is there a restart sequence I need to follow?
Help much...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 9, 2010 at 3:07 pm
If you decide to do the restore make sure you build in a step to update all statistics on the database. Even better would be to rebuild all the indexes.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 14, 2010 at 7:12 am
Some more information on this can be found here. This is 2000 related but still applicable.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 1, 2010 at 9:33 am
One example can be found here.
A good summary of locking here.
BOL is a good resource here as well.
Hope this helps.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 1, 2010 at 7:09 am
Unfortunately snapshot replication is per database so, you would have to set it up 300 times if that is the number of databases you have to copy.
Honestly your best...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 15, 2009 at 3:08 pm
Just a couple of thoughts;
- script out all logins; Have these in place prior to moving databases
- all jobs from msdb
- any user objects (tables, procedures) in system databases;...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 20, 2009 at 7:51 am
What kind of publication is that? You had stated no logreader agent and you were trying to create a snapshot (which should be easily recreatable). Merge?
Regardless read the documentation...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 20, 2009 at 4:36 am
If you see nothing in the output from the following query then you can disable replication for that database.
select * from syspublications -- will check if there are any...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 19, 2009 at 9:52 am
SQL Noob (11/19/2009)
we went from 32 bit SQL 2005 to 64 bit a few years ago. all databases are on...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 19, 2009 at 9:39 am
What do you see when you run select log_reuse_wait_desc,name from sys.databases for the database in question?
Check out this post and see if it helps.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 19, 2009 at 9:35 am
If you are going with the same version of SQL then you might be ok. I will say that if you are going to use restore then you will need...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 19, 2009 at 9:17 am
Are you seeing a log reader agent? What do you get when you run the following on the distributor?
use distribution;
go
select * from MSlogreader_agents
Do you see a log reader agent...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 19, 2009 at 9:08 am
SQL DBA 808 (11/11/2009)
Thank you so much. I could not find that anywhere on the net or in Books online.
I only know it as we have had to work...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 11, 2009 at 2:31 pm
You have to drop the subscriptions, then go to publication properties, subscription options, top option is independent agent. Set that to false. Sadly you can't change it unless you have...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 11, 2009 at 2:16 pm
Glad you figured it out but I'm surprised that not starting the snapshot agent caused your subscription not to be created as they are not really connected. I wonder if...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 4, 2009 at 1:59 pm
Viewing 15 posts - 541 through 555 (of 1,790 total)