+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
MIS Systems Thread, Cannot login after SIMS SQL restore in Technical; I would avoid doing hourly differential backups as each differential contains all of the changes since the previous full backup. ...
  1. #16
    skunk's Avatar
    Join Date
    Mar 2006
    Location
    North West
    Posts
    311
    Thank Post
    88
    Thanked 40 Times in 33 Posts
    Rep Power
    30
    I would avoid doing hourly differential backups as each differential contains all of the changes since the previous full backup. Transaction log backups remain small as they only contain the changes since the last transaction log backup was taken.

    Now that I have confirmed the process works successfully, I was going to pop my documentation onto the edugeek wiki, but editing has been turned off.

    @vikpaw Yes, all I had to do was run the sims.db_p_install script
    Last edited by skunk; 14th May 2012 at 10:33 AM.

  2. #17

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,969
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I do daily FULL backups. It's too much space to do more than that. Haven't tackled the logs, though used to. Mostly the requirement is restoring for testing or pulling back / checking on some old data. If it truly was a disaster, one day's loss wouldn't be that bad in the grand scheme of things.

    If anyone is doing differential or incremental, be careful that you only have one backup system (i.e. backupExec, or NT backup, or manual, or SQL studio) talking to the database else you will corrupt the backup regime. Two different systems which is what i had at one stage, each going in and doing their own thing, means only the full backups will work. I learnt the hard way, when i was doing my own system and the NM had BackupExec with an SQL agent going in and doing something else.

  3. Thanks to vikpaw from:

    skunk (14th May 2012)

  4. #18

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,970
    Thank Post
    113
    Thanked 490 Times in 336 Posts
    Blog Entries
    2
    Rep Power
    283
    Quote Originally Posted by vikpaw View Post
    If anyone is doing differential or incremental, be careful that you only have one backup system (i.e. backupExec, or NT backup, or manual, or SQL studio) talking to the database else you will corrupt the backup regime. Two different systems which is what i had at one stage, each going in and doing their own thing, means only the full backups will work. I learnt the hard way, when i was doing my own system and the NM had BackupExec with an SQL agent going in and doing something else.
    Good point, Vik.

    Backup operations in tandem, whether it's an SQL script or a third party agent like Veritas will affect the log file, and these competing backup operations are certain to ruin the backup chain.

    Sometimes however, you will need to make an ad-hoc backup, perhaps to test something. In this case it's possible to make a backup with the COPY_ONLY flag set either from an SQL statement or through the manager console. In either case, this 'COPY_ONLY' backup has absolutely no effect on the log files, which is very, very useful if you need to make a one-off backup without ruining your backup set.

    Copy Only Backup for SQL Server 2005 and SQL Server 2008


    Copy-Only Backups (SQL Server)
    Last edited by jinnantonnixx; 14th May 2012 at 02:27 PM.

  5. 2 Thanks to jinnantonnixx:

    skunk (14th May 2012), vikpaw (14th May 2012)

  6. #19
    skunk's Avatar
    Join Date
    Mar 2006
    Location
    North West
    Posts
    311
    Thank Post
    88
    Thanked 40 Times in 33 Posts
    Rep Power
    30
    We had a four hour loss a few months back and the hassle was immense, so down to an hour now, could try 15mins as per @jinnantonnixx, but that will have to wait for another day.

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. [SIMS] SIMS SQL 2008 Migration
    By Nik in forum MIS Systems
    Replies: 8
    Last Post: 13th February 2011, 10:26 PM
  2. [SIMS] SIMS SQL Version...
    By IKWeb in forum MIS Systems
    Replies: 30
    Last Post: 12th February 2011, 08:25 AM
  3. [SIMS] SIMS SQL 2008 - How much memory do you have allocated?
    By Max_Power in forum MIS Systems
    Replies: 15
    Last Post: 5th December 2010, 09:02 AM
  4. moved sims sql database but logins not moved
    By Jamie_a in forum MIS Systems
    Replies: 3
    Last Post: 13th November 2010, 10:06 AM
  5. [SIMS] SIMS SQL 2005 --> 2008 migration
    By cookie_monster in forum MIS Systems
    Replies: 7
    Last Post: 29th July 2010, 02:24 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
  •