Forum Discussion

nathanmace's avatar
nathanmace
Level 3
17 years ago

MS SQL Databases Not Being Backed up

I've got a 2005 SQL server with about a dozen databases on it.  In Backup Exec when I setup a backup job for that server (with the SQL agent), I select the databases and the drives that contain the data and log files for the databases.  The mdf and ldf files.  When the backup runs, it completes successfully (except for an error about requiring sp 2 to do snapshots which I take to mean sp 2 on the database server since I have sp 3 of backup exec) however it never backs up the mdf and ldf files!  Even though I explicitly selected them.

Any ideas?  I've done everything I know to do, though I will admit my knowledge of databases isn't all that great.  Any help would be appreciated.
10.x and Earlier
Backup and Recovery
Backup Exec
  • nathanmace's avatar
    nathanmace
    Level 3
    17 years ago
    OK.  Next bit of info.

    I'm having trouble restoring a database that was backed up with the SQL agent.  I need to do a redirection and restore it to a new/blank database I created just for the purpose of holding a "old" copy of a database from earlier in the week.

    I do the restore + redirection and the job completes successfully.  However no data gets put in the database.  None of the tables are created...nothing.  No errors in the database servers event log, and nothing from Backup Exec.  I initially thought it was because the ldf/mdf files weren't being backed up.  But that doesn't seem to be the case.  Any ideas as to why the data isn't being written to the newly created database?
  • nathanmace's avatar
    nathanmace
    Level 3
    17 years ago
    Bump.

    Anyone have any ideas as to why my restore job isn't actually putting any data in the database?  Thanks.
  • Ken_Putnam's avatar
    Ken_Putnam
    Level 6
    17 years ago
    Don't have a clue
     
    After  the restore, is your production database still OK, or was it overwritten rather than the actual target, was it?
  • THG's avatar
    THG
    Level 3
    17 years ago
    are there active connections to the new database?

    right click the new, empty database in Enterprise Manager choose the option to Detach Database and verify that the current connections is set to 0..........if there is 1 or more clear them out and retry the restore.

    how long does the restore take to run? if it finishes in a couple of minutes (the time it takes to queue up the tape) and immediately finishes it is most likely because backup exec cannot obtain a lock on the database
  • nathanmace's avatar
    nathanmace
    Level 3
    17 years ago
    It takes it over 4 minutes to do the restore...so it doesn't seem to load the tape and fail.

    When I go to the detach screen, I don't see any way of telling if there are any active connections?  That might be because I'm not using Enterprise Manager.....I'm using SQL Server Management Studio.