Chris,

in my experience there are 3 possible reasons why a job would not run.

1. SQL Agent is not running

2. The schedule isn't enabled

3. The scheduled time has already passed

For the...

From BOL:

Right-click the Replication folder or any of its subfolders, and then click Launch Replication Monitor.

Markus

Roger,

where's actually an issue with task manager showing the wrong amount of memory used by sql server if your using more than 3gb. Use Performance monitor and you see the...

Not sure if this is related, but I experienced the same error when trying to creae a unique clustered index in Management Studio. The error complaint about duplicate values, even...

Chris,

one thing to keep in mind then attaching a SQL 2000 datbase is that most new features are only availbale after you change the compatibility level to 90.

Markus 

I agree with Richard.

Even though I guessed my answer (D), the Explanation don't make things any clearer and without a SQL2005 server at hand I can't check the real...

Kirk,

thnks for the reply, but while you can delete a package by connecting to Integation Services there's no edit or properties option. Do I have to export the package...

Philip,

I've never tried and I wouldn't advise doing it. I remember a customer which once restored his master database from an old machine to a newer one and it turned...

see my answer in the replication form

I had the same issues a while ago and created a  script which cleans all the leftovers of merge replication.

I don't like to post it because it's quite rough and...

Isabelle,

the 85 % threshold is based on the current logfile size not on the max allowed size of 6Gb.

If you only want the logfile backuped then 85 % of 6...

At first sight I would say you don't do anything wrong, and executing the code works. What could cause your problem is the "with file = 1" option.

If your backup device...

Which account do you use ? Is it a domain account or a sql account ? Maybe the password has changed .

M

Assuming that your accounts have db_owner rights in your database, you could give one account access to all your databases. When use that account to backup your databases.

Hope this helps

M