Issue: I have a MSDE SQL database that needs to return it to the original state after it is shown to customers.
I would like to create a job that will
Detach the database,
Copy the .mdf and .ldf file from a backup location located on the same machine
Attach the database.
Question:
If I use Enterprise Manager from another SQL server (Across Network) will this affect the
The way the job is run?
Using jobs on a MSDE database, will it affect the database performance?
Any help on this would be great.
Thanks in advance
Kenos
I would like to create a job that will
Detach the database,
Copy the .mdf and .ldf file from a backup location located on the same machine
Attach the database.
Question:
If I use Enterprise Manager from another SQL server (Across Network) will this affect the
The way the job is run?
Using jobs on a MSDE database, will it affect the database performance?
Any help on this would be great.
Thanks in advance
Kenos