Are you sure you are on SQL Server 2000 because as per my knowledge SQL Server Agent Proxy Accounts are new to SQL Server 2005.

Just check.

You can download the guide from here also. 🙂

All you need is C2 Administrator’s and User’s Security Guide Revision 1.1

you can donwload this guide from :

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=71C146F3-9907-40CD-BABF-3506ECD33254

Hi David,

I don't know why you are using the same SQL Box to design the DTS Packages.

You can try this, Install SQL Server Client tools on some other test server,...

DONE

I'll recommend to use the below script

[Code]select 'tablediff -sourceserver .\sql2k5 -sourcedatabase test12king -sourcetable '

+ TABLE_NAME

+ ' -destinationserver . -destinationdatabase test12king -destinationtable '

...

If you're testing this on the same server then its Ok

otherwise you need to backup and restore the Service Master key also.

You can take the backup of

Master key as well as the Certificate with the below mentioned scripts:

From the Instance which you've restored from your backup

backup master key to file...

The problem is with the backup set, either it is not available or your ID is not authorized to use that.

In place you can copy the backup to a local...

What solution you are talking abt with DB Snapshot?

Pls. run getdate() and then check this time with the logs its generating.

Both the times should be same. (there can be a small diff. but that much diff. is not...

Team pls. share your views.

1. Backup job runs every 1 hrs

2.Delete files older than 72 hrs

3.Alert if no backup occurs with in 2 hrs

4.Copy job runs every 1hrs

5.Delete files older than 72 hrs

6.Restore job...

In Snapshot replication it creates a snapshot at once and apply...

I think i am out of sync.

As far as i know, Its not possible to intall SQL Server Agent only, And if you are installing SQL Server it comes with...