Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Restore as fails, says it cannot use backup set

Posted on 2006-03-30
2
Medium Priority
?
479 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
0
Comment
Question by:colis
2 Comments
 
LVL 20

Accepted Solution

by:
Sirees earned 2000 total points
ID: 16337138
0
 

Author Comment

by:colis
ID: 16337691
Thanks.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question