Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249

    Red face Unanswered: Optimal restore of database

    How can I restore Database_1 on MSSQL2K server with minimal effect on working users of Database_2 ?
    When I use EM (restore with create), users are getting "General network error" for 5 minutes.

  2. #2
    Join Date
    May 2002
    Posts
    299

    Re: Optimal restore of database

    Hopefully you're not pulling the backup from across the network. Remember that, restoring does take some taxing on the server resources. However, this should not drop your users.

    Take a look at perfmon/netmon to see what's going on.
    --
    -oj
    http://www.rac4sql.net

Posting Permissions

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