Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SQL server Database restore error 3219

Posted on 2007-07-26
Medium Priority
Last Modified: 2010-08-05
Installed SQL Server 2005 Dev. edition on windows 2003 server

I am trying to restore the backup whic i taken  few hours before using Restore Files and FileGroups... in the SQL Server Management studio. It throws the following error message

The  file or filegroup "XXDB_log" cannot be selected for this operation. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3219)

The backup is from the same database

Please could someone help me on this one i really need a quick answer
Question by:shieldguy
  • 2
LVL 14

Accepted Solution

twoboats earned 2000 total points
ID: 19576965
Have a look here


I believe you want to Restore Database not restore file or filegroups

Author Comment

ID: 19581006
Yes you are right many thanks
LVL 14

Expert Comment

ID: 19581104

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

564 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