We help IT Professionals succeed at work.

Restore as fails, says it cannot use backup set

colis
colis asked
on
Medium Priority
512 Views
Last Modified: 2008-03-17
I'm trying to restore a sql 2000 db as another database.  I'm trying to retore only one table so I don't want to restore over the original database.  The database is set to backup each night to a file called crw.bak.  It then does tlog backups every hour during the day.  In EM I select the original db and choose restore as and name a new db, change the paths and select force restore.  I get the error: 'The backup set in file '\\..crw.bak' was created by BACKUP LOG and cannot be used for this restore operation.  RESTORE DATABASE is terminating abnormally.'  This backups works fine when we have had to restore over the original in the past.  Any ideas?

FYI my backup script reads like this:

BACKUP DATABASE [CRW] TO [CRW] WITH  INIT ,  NOUNLOAD ,  NAME = N'CRW backup',  NOSKIP ,  STATS = 10,  NOFORMAT

Thanks,
COLIS
Comment
Watch Question

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.