+ Post New Thread
Results 1 to 7 of 7
Windows Thread, Ntbackup problem in Technical; Hi guys, Recently upgraded to SQL 2005 on our admin server and, since then, backups don't appear to be going ...
  1. #1
    WithoutMotive's Avatar
    Join Date
    Feb 2006
    Location
    Wigan, UK
    Posts
    631
    Thank Post
    41
    Thanked 49 Times in 43 Posts
    Rep Power
    27

    Ntbackup problem

    Hi guys,

    Recently upgraded to SQL 2005 on our admin server and, since then, backups don't appear to be going too well.

    We back up C:, D: and the System State to tape.
    What's happening is that C: is being backed up but then the tape is ejected without giving the chance for D: to start or the System State.
    I can guarantee that the tape cannot be full because the C: drive hasn't even got 10GB of data on it and the entire system can usually fit on a tape.
    Both drives can also back up individually when I perform a test backup.

    Something I thought of was that maybe the SIMS database would be in a locked state and therefore not allow a backup so last night I stopped the SQL Server service and the SQL Server Agent service but this didn't make any difference.

    Any suggestions?

    *EDIT* - sorry, running Windows Server 2003 R2 if that's any help

  2. #2
    mrforgetful's Avatar
    Join Date
    May 2006
    Posts
    1,639
    Thank Post
    7
    Thanked 15 Times in 15 Posts
    Rep Power
    23

    Re: Ntbackup problem

    Could be appending data instead of overwriting?

    ntbackup won't backup your SQL, what do you use for that?

  3. #3
    ajbritton's Avatar
    Join Date
    Jul 2005
    Location
    Wandsworth
    Posts
    1,632
    Thank Post
    23
    Thanked 75 Times in 45 Posts
    Rep Power
    35

    Re: Ntbackup problem

    Backup logs?

  4. #4
    Joedetic's Avatar
    Join Date
    Jan 2006
    Location
    Walsall
    Posts
    1,316
    Thank Post
    6
    Thanked 13 Times in 13 Posts
    Rep Power
    23

    Re: Ntbackup problem

    mrforgetful is right...ntbackup wont do SQL. Veritas Backup Exec will though if you buy the SQL client thing.

  5. #5
    ajbritton's Avatar
    Join Date
    Jul 2005
    Location
    Wandsworth
    Posts
    1,632
    Thank Post
    23
    Thanked 75 Times in 45 Posts
    Rep Power
    35

    Re: Ntbackup problem

    If you want an inexpensive SQL backup solution, you could have a look at BackupAssist, which has an SQL plug-in available. Educational pricing available.

  6. #6
    daveyboy's Avatar
    Join Date
    Jun 2005
    Location
    Bath / Bristol
    Posts
    282
    Thank Post
    41
    Thanked 23 Times in 19 Posts
    Rep Power
    23

    Re: Ntbackup problem

    If you want an inexpensive SQL backup solution, you could have a look at BackupAssist, which has an SQL plug-in available. Educational pricing available.
    Just to say I am using this (with this with the SQL plug-in).
    I've found this to be really good.

  7. #7
    mrforgetful's Avatar
    Join Date
    May 2006
    Posts
    1,639
    Thank Post
    7
    Thanked 15 Times in 15 Posts
    Rep Power
    23

    Re: Ntbackup problem

    We're having trouble with Backup Assist connecting to our new SQL2005 database, don't want to hijack the thread though!



SHARE:
+ Post New Thread

Similar Threads

  1. ntbackup B2D scheduled job problems
    By randle in forum Windows
    Replies: 2
    Last Post: 2nd July 2007, 03:05 PM
  2. ntbackup help please :S
    By techyphil in forum Windows
    Replies: 16
    Last Post: 18th June 2007, 03:19 PM
  3. Replies: 5
    Last Post: 30th April 2007, 09:40 AM
  4. NTBackup
    By Gatt in forum Windows
    Replies: 3
    Last Post: 4th January 2007, 12:16 PM
  5. NTBACKUP - What does it actually backup?
    By ajbritton in forum Windows
    Replies: 1
    Last Post: 7th December 2005, 10:31 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
  •