+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 23
MIS Systems Thread, Backing up SIMS.net in Technical; Hi first post so take it easy on me! Have a new sims server 2003 runing sql2005. I need to ...
  1. #1
    training_needed's Avatar
    Join Date
    Feb 2008
    Location
    Somewhere over the rainbow
    Posts
    43
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Backing up SIMS.net

    Hi first post so take it easy on me! Have a new sims server 2003 runing sql2005. I need to back it up the problem comes in the form of no tape drive in the server! ( i have nothing to do with ordering servers) Can i back it up to a hard drive attached via USB and I just use NT Backup? Any other ideas would be greatfully taken.
    training needed

  2. #2
    BKGarry's Avatar
    Join Date
    Mar 2006
    Location
    Kent
    Posts
    908
    Thank Post
    92
    Thanked 118 Times in 95 Posts
    Rep Power
    46
    The USB drive with NTBackup would be fine, esepecially is you use USBDLM so it always uses the same Drive letter when you insert it.

    Personally here, we have one server with a large tape drive and backup all of ourservers using symantec backup exec with the remote agent.

  3. #3
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    Get yourself a tape drive squire - you wouldn't want anything to happen to that USB hard disk...

    Tapes might need a bit of setting up but once you've got them going they are ideal for your needs.

    You could also weigh up a remote backup option so long as it has an SQL Server plugin...

  4. #4
    training_needed's Avatar
    Join Date
    Feb 2008
    Location
    Somewhere over the rainbow
    Posts
    43
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    cheers for that BKGarry where you from in the northflleet as thats where i from! We have a sony autoloader with 7 tapes and it was my plan to backup up onto this but when i bought the extra remote agent the supplier sent me version 11d said they could not get 10d anymore but we have 10d on the main server and i can't seem to get the two to work together?
    training needed

  5. #5
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41
    I couldnt get the remote agent to work at all.. it would only backup system state but kept saying it didnt have access to the drives i.e. any shares including the admin ones like c$. As an interim solution i use dbattach to create a backup of the database, then i copy the zip file onto another server which backs it up to tape.

  6. #6

    Join Date
    Feb 2007
    Location
    East Sussex
    Posts
    457
    Thank Post
    16
    Thanked 84 Times in 76 Posts
    Rep Power
    30
    If you've got a backup device on another server, then you could just use NT backup on the sims server and backup to a file on another server. This would then get copied to tape that night, if scheduled to run before your tape backup job.

    Could even just use a maintenance task in SQL to make the .bak files from your sql database, and a scheduled xcopy job to copy them to another server?

    Steve

  7. #7
    altecsole's Avatar
    Join Date
    Jun 2005
    Location
    Morecambe, Lancashire, UK.
    Posts
    281
    Thank Post
    39
    Thanked 36 Times in 26 Posts
    Rep Power
    25
    Quote Originally Posted by training needed View Post
    Hi first post so take it easy on me! Have a new sims server 2003 runing sql2005. I need to back it up the problem comes in the form of no tape drive in the server! ( i have nothing to do with ordering servers) Can i back it up to a hard drive attached via USB and I just use NT Backup? Any other ideas would be greatfully taken.
    training needed
    We use DBAttach.exe to create a zipped backup of the SIMS database and then use NTBackup to backup to a network location (Buffalo Terastation). We also do a local backup on a Friday to a local USB drive for offsite storage.

  8. #8

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180
    Would it not be easiest to simply use a Maintenance Plan to backup the SIMS database directly to a share on another server that can copy to tape for you?

  9. #9
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    I agree with Ric,

    If you can't get a tape drive in the thing back it up to a mounted drive on a server that does have a tape drive and get it in that way.

    DVD-R's could be another option?

  10. #10
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41
    Correct me if im wrong but that doesnt zip up the database (just creates a .bak file) and isnt there an issue with users passwords being reset if you restore it from a bak file? Maintenance Plan is probably more tidy but i wouldnt say its easier, just another way to do it.

  11. #11
    altecsole's Avatar
    Join Date
    Jun 2005
    Location
    Morecambe, Lancashire, UK.
    Posts
    281
    Thank Post
    39
    Thanked 36 Times in 26 Posts
    Rep Power
    25
    Quote Originally Posted by apeo View Post
    Correct me if im wrong but that doesnt zip up the database (just creates a .bak file)
    If you're talking about using DBAttach.exe then no. It creates a zip file with the date as part of the file name - dead easy then then backup using whatever method you like.

  12. #12
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41
    Quote Originally Posted by altecsole View Post
    If you're talking about using DBAttach.exe then no. It creates a zip file with the date as part of the file name - dead easy then then backup using whatever method you like.
    I already know DBAttach does zip up the file (as i stated in a post above ive used it in the past) and i was talking about Maintenance Plans.

  13. #13

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180
    Maintenance plans do not zip the file by default... although I think you can add extra actions in there. It does tidy up the whole backup and scheduling though and it can dump directly to anywhere on your network. Using a maintenance plan is also an incredibly quick way to perform a backup!

  14. #14
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41
    Quote Originally Posted by Ric_ View Post
    Maintenance plans do not zip the file by default... although I think you can add extra actions in there. It does tidy up the whole backup and scheduling though and it can dump directly to anywhere on your network. Using a maintenance plan is also an incredibly quick way to perform a backup!
    Is there an issue when restoring tho? i.e. all the user passwords get reset.

  15. #15
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    The username passwords can get reset when you move from SQL (old style MSDE) to SQL 2005/Express. It's something to do with the master.ldf/mdf pair not being read properly.

    This also happened to us moving from 32 bit Server to 64 bit server.

    Way around it is to create your backup in DBAttach (latest version) first, then restore your backup via dbattach too.

    (To be on the latest DBAttach run SIMSSQLApplicationSetup first)

    Commandline, at the ........MSSQL.1\MSSQL\Binn folder,

    DBAttach /RESTOREUI



    This gives you an extra option on DBAttach to restore a previously backed up database and this uses the SIMS.bak file but also reads from the master.bak file (don't ask me how it just works).

    Not had a problem with losing passwords since I've been restoring via DBAttach /RESTOREUI.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 7
    Last Post: 20th February 2008, 04:37 PM
  2. backing up
    By gwendes in forum How do you do....it?
    Replies: 7
    Last Post: 13th November 2007, 09:06 AM
  3. Backing Up System State
    By mrforgetful in forum Windows
    Replies: 27
    Last Post: 11th January 2007, 02:04 PM
  4. Backing up SQL database ?
    By Kyle in forum Windows
    Replies: 4
    Last Post: 8th June 2006, 09:36 PM
  5. Mac software for backing up DVDs
    By dagza in forum Mac
    Replies: 14
    Last Post: 23rd May 2006, 11:29 AM

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
  •