+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, sims restore in Technical; I have recently for my own piece of mind been revisiting my disaster recovery strategy and so attempted to restore ...
  1. #1

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17

    sims restore

    I have recently for my own piece of mind been revisiting my disaster recovery strategy and so attempted to restore my sims database from a recent back up i use arcserve to backup and it seems to work without fault however in order to recover i need exclusive access to the sims database when i use sql manager to attempt this it tells me that it can't be in single use mode while others are logged on, its quite late and no-one is logged on how can i force it to kill any sessions it thinks it has?
    thanks in advance.

  2. #2

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: sims restore

    Others will correct me if I'm wrong but I don't think it matters.
    Whe you recover you will be overwritting the live database anyway.
    Proabably just restarting the SQL Server service should be ebough.
    Also temporarily change the permissions for the S: drive.

  3. #3

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17

    Re: sims restore

    ok thanks networkgeezer i'll ty that.

  4. #4
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    952
    Thank Post
    37
    Thanked 167 Times in 134 Posts
    Rep Power
    95

    Re: sims restore

    It is also possible to run a scheduled DB attach backup to create a backup of the SIMS database that can be copied to the tape.

    Our schools use this system to ensure that the database is live at all times and data can be backed up.

  5. #5
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    952
    Thank Post
    37
    Thanked 167 Times in 134 Posts
    Rep Power
    95

    Re: sims restore

    It is also possible to run a scheduled DB attach backup to create a backup of the SIMS database that can be copied to the tape.

    Our schools use this system to ensure that the database is live at all times and data can be backed up.

  6. #6

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17

    Re: sims restore

    ah ok does this get around the database being locked all the time?

  7. #7
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    952
    Thank Post
    37
    Thanked 167 Times in 134 Posts
    Rep Power
    95

    Re: sims restore

    yeah cause you are working within the database. This routine uses the SIMS built in sql users. It is also worth considering any other product you have attached to the database. We have schools that use PARS for registration and this can stop any SIMS database being able to go into single user mode.

  8. #8
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    952
    Thank Post
    37
    Thanked 167 Times in 134 Posts
    Rep Power
    95

    Re: sims restore

    yeah cause you are working within the database. This routine uses the SIMS built in sql users. It is also worth considering any other product you have attached to the database. We have schools that use PARS for registration and this can stop any SIMS database being able to go into single user mode.

SHARE:
+ Post New Thread

Similar Threads

  1. Can I restore a SIMS server to a VM
    By nicholab in forum MIS Systems
    Replies: 11
    Last Post: 9th November 2007, 06:42 PM
  2. Restore scheduled tasks
    By Jobos in forum Windows
    Replies: 1
    Last Post: 22nd June 2007, 12:07 PM
  3. Restore Problems
    By Grommit in forum Wireless Networks
    Replies: 3
    Last Post: 6th March 2007, 08:53 AM
  4. Simple backup and restore
    By adamyoung in forum Wireless Networks
    Replies: 7
    Last Post: 25th August 2006, 08:13 AM
  5. Windows Back Up / Restore.
    By tickmike in forum Windows
    Replies: 24
    Last Post: 23rd August 2006, 03:20 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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