March 14, 2006 at 8:09 am
I'm using SQL server enterprise manager to back-up a schedulling database on SQL Server 2000. However, when I attempt the back-up I get the following error message:
MS SQL -DMO (ODBC SQLSTATE: 42000)
Media set for database "schedwin" has 2 family members but only 1 are provided. All members must be provided. BACKUP DATABASE is terminating abnormally.
What's gone wrong, it's worked OK before. The dataset seems to be working fine. There are 2 "Backup to:" destinations listed in the SQL server backup dialog window - does this have any bearing on the matter. A parallel test database called schedtest only has one destination listed and backs-up fine.
I need to make a back-up to send to a support department via ftp - could I use export instead? By the way the server automatically creates back-ups every night.
You will have guessed by now that I am a complete novice to MS SQL server - so please explain as to a three year old!
regards
Llywelyn Owen
March 14, 2006 at 8:27 am
I have no idea why you see this problem. However, you might just try a maintenance plan to get your regular backup run.
In EM, right-click on "maintenance plans" for your server and select "new maintenance plan" from the context list. It's a wizard of sorts and will prompt you for a few things.
Select only the items you really need and be sure to pick a reasonable purge retention for the backups, otherwise they'll stack up forever.
You will be prompted for the time of day that backup is to run, be sure to fill that part in to meet your needs with the daily backup copy.
SQL Agent must be running on your system for this to work. If you want to copy the database backup to another system, you can create a second job in SQL Agent to do the copy (I'm pretty certain maintenance plans don't like you fiddling with their job steps).
Be sure to name your maintenance plan (one of the panels towards the end of the process) with some useful name.
If this database is fully logged and you have some other backup plan in existence for it, this may complicate things.
On the other hand, if you're a complete novice, we're all going to be concerned that you're getting no backups at all. You might look at a general maintenance plan to accomplish that.
Best of luck!
March 15, 2006 at 6:36 am
Thanks for that reply. I've now managed to make a backup by actively selecting one of the destinations offered and I've restored successfully to a test databse. My problem was with "forced" backups - if that's the right term. I've also ordered a hopefully good manual on the subject of using SQL server enterprise manager....
I know for a fact that the database is amatically making a full back up every night and that the backups have been tregularly test restored in our test database, perhaps soon we can move over to daily incremental backups and full weekly backups.
Thanks again for your help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply