sp_helpfile shows 2 backup has 4 files - please help

• Graham Stevenson-265370

  SSC Rookie

  Points: 28

  More actions

  November 5, 2005 at 3:37 pm

  #89824

  Hi,

  I have a database which tells me it is some 1.5 GBytes. Run sp_helpfile and it shows 2 files. These are on D:.

  There are however 2 more files (on C which grow with this database. These files were added when the existing files ran out of disc space. One of these files is > 6 GB. Neither show in sp_helpfile, OR in the database sysfiles or sysfiles1 but they DO appear in Master.sysaltfiles.

  The backups show all 4 files, BUT when restoring I get a failure in FileMgr.cpp line 1745 !!.

  The issue seems to be with the orphaned log file (on C.

  All attempts so far have used EM, but I also tried using QA to specify restore database with norecovery. This worked !! - in that it didn't generate a failure. Now however I have a database awaiting completion of a restore but I have no further log files.

  Any ideas would be MOST welcome :-).

  Many Thanks

  Graham

  When I subsequently tried Restore database xxxx with recovery - I get the same error as previously :

  Server: Msg 3624, Level 20, State 1, Line 1

  Location: filemgr.cpp:1745

  Expression: IS_ON (FCB_LOG_DEVICE, saflStatus) || IS_ON (FCB_DROPPED, saflStatus)

  SPID: 56

  Process ID: 1968

  Connection Broken

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  November 8, 2005 at 9:29 am

  #602810

  Can you post your restore script ?

   

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."