You're right about the @sync_type parameter. A value of 'none' should indicate that the subscriber already has the schema and data is synchronised.

What parameter value are you using?

Markus

G

I would do 2 things. You obviously can't stop these attempts as long as you don't know where they originate from so:

First of all rename the sa account, so...

If I read it correctly your making a tranasaction log backup every 5 minutes to the same backup device.

BACKUP LOG [ECOMLIVE] TO [ECOMLIVE Log] WITH  INIT ,....

The problem is the...

http://www.tpc.org/

Markus

Can't say I ever used this option but keeping in mind all the changes to 2k5 maintenance plans in SP1 + 2 I'd rather create new plans in SSMS. In...

I agree with Ninja and like to add one request.

Currently you only see 10 questions at a time. This makes it almost impossible to find some older questions.

Markus

I can't claim to be an expert on the field of RMO, but this link should help you getting started.

http://msdn2.microsoft.com/en-us/library/ms147926.aspx

Markus

Paul, I don't know where you've read that Server Admin can execute this procedure, but when you execute the code in a query window the error message tells you that "Only...

Have a look here:http://support.microsoft.com/kb/811889

Then restoring a dropped database, it can get a different ID. Looks like the job definition somehow contains the old database ID. Check the steps in the job for any...

As you said yourself, it depends on the requirements. How big is your database, how many transactions happen every day, what amount of dataloss is acceptable, how long is your...

Probably the best quality courses you can find at Solid Quality Leraning. All courses are held by real experts all of them MVP. The disadvantage is that they are more...

Actually the warning is there because in SQL 2000 you have the option to save a package as Meta Data package in the repository. IN SQL 2005 this option no...

As I wrote before it depends on the service pack version where you find them.

For the RTM and SP1 do the following steps :

1. Open Management Studio
2. Highlight a server...

SSMS contains a couple of standard reports. Depending on which SP you have installed you can either find them at the top of the summary window (Pre-SP2) or by right-clicking...