Our problem is that the packages were done on the PRODUCTION environment. Our test environment does not have the same components in this case drivers for the ODBC connection to...

Thoams Vu,

Based on your answer the developers wont have logon (Remote Desktop Access) access to the PRoduction Server, correct?

The packages were created on the production server and now need to be modified. The developer can't run it from its local computer because the ODBC connection that the DTS...

Resolution:

We will implemet database triggers for tables in the database to insert, update, delete activity. Also create a trace to monitor who is trying to access the database outside the...

Does anyone knows how to change a post between forums?

Thank You all for your suggestions. I proceed to create a job to run after the nightly backup to restore the newdatabase using the old database backup file. Then I also...

The environment is SQL 2000

However, the restore needs to be on the same isnatnce, same server of the original database using a new name.

Hopefully, however thread is referring to two file *.cmd containing system variables that I can't understand. Seems that I missing a big key in this puzzle....

Currently trying to test restore scenario from backup on our shop, similar with what you tried in here. However, on Step 6A you refer to the parameter information on the...

From the error log, after restoring master SQL tries to start up and it can't. See messages:

Starting up database 'master'.

May 18, 2006 at 12:06 pm