error when restoring a database
-
When restoring a database I'm getting the following error:
The media set for database 'database-name' has 2 family members but only 1 are provided RESTORE DATABASE is teminating abnormally.
I've done quite a few restores in my time but never seen anything like this... does anyone know what this error means?
Cheers
Mark
-
forget I ever asked this question!
Problem all sorted I'd forgotten to remove the previous backup thus it backed up into 2 files.
I feel a bit silly.
-
"tell me why I don't like Mondays"
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
H!! ,
while you are attaching a database you have to provide data file and log file..if you don't have a log file you have to attach only the da file using sp_attach_single_filedb option..
regards,
vinod
-
H!! ,
while you are attaching a database you have to provide data file and log file..if you don't have a log file you have to attach only the da file using sp_attach_single_file_db option..
regards,
Vinod (DBA)
HTCGlobal Services Chennai
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply