Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 524
  • Last Modified:

SQL backup/restore Schedule Job

I need help creating a scheduled backup job for SQL and a restore job as well.

Here is the name of the database that needs backed up Service.  I need that backed up then once backed up I need it to Delete ServiceTR database and then do a restore of Service database as ServiceTR.  Any help would be great.
0
HB-IT
Asked:
HB-IT
1 Solution
 
HB-ITAuthor Commented:
can you express it how I need it done not sending me a link to some other answer.  That does not work for me.

I need a backup of Service
Delete ServiceTR
Restore Service as ServiceTR
this all needs to be a schedule job.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now