Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    7

    Arrow Unanswered: Scheduled Restore DB in EM?

    Dear All,

    We all know that we can schedule backup DB & Log in EM using Database Maintenance Plan.

    Is there a way we can schedule Restore DB using EM?

    Anyone?

    Thanks.

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Yup ... write the sql code to do so and schedule as a job.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Mar 2004
    Posts
    7
    Thanks Enigma... seems like that's the only option.

    rgds

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    I presume you will know better if you read thru BOL as a first hand help.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Mar 2004
    Posts
    7
    Thanks Satya... your prevision is true.

    I managed to get the job done... writing the script and scheduled as job.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •