Results 1 to 11 of 11

Thread: need help here pls SQL server restore database urgent

Threaded View

  1. Feb 27th, 2007, 06:48 AM #1
    mikee_phil
    mikee_phil is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2006
    Location
    Philippines
    Posts
    468

    need help here pls SQL server restore database urgent

    i created a full backup FAASdatabase_db_200702251902.BCK when i tried to restore the back up set on a different database (force restore) complete i get this error
    a Code:
    1. restore database faasdatabase

    2. from disk='D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\

    3. FAASdatabase_db_200702251902.BCK'
    Code:
    Server: Msg 3135, Level 16, State 2, Line 1
The backup set in file 'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\FAASdatabase_db_200702251902.BCK' was created by BACKUP LOG and cannot be used for this restore operation.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
    the i try restore log
    Code:
    Server: Msg 4306, Level 16, State 1, Line 1
The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
    i got this error
    Code:
    restore log Faasdatabase 
FROM DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\FAASdatabase_db_200702251902.BCK' 
with norecovery
    Last edited by mikee_phil; Feb 27th, 2007 at 07:20 AM.
    if you have a problem face it
    but what if your face is your problem
    how can you face it
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width