Link to home
Start Free TrialLog in
Avatar of Bob Schneider
Bob SchneiderFlag for United States of America

asked on

SQL Server Backup Problem

I am trying to set up a sql server 2k backup system where I have a complete back-up every day and transaction log backups every hour.  When I try to create the transaction log backup I get an error indicating that "...is not part of a multiple family media set..."  

Any ideas?
Avatar of mohan_sekar
mohan_sekar
Flag of United States of America image
Could you post the backup statement?
Avatar of Bob Schneider
Bob Schneider
Flag of United States of America image

ASKER

I am just using the Enterprise Manager wizard for this.
ASKER CERTIFIED SOLUTION
Avatar of Jagdish Devaku
Jagdish Devaku
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of DBAduck - Ben Miller
DBAduck - Ben Miller
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jagdish Devaku
Jagdish Devaku
thats gr8... extension of the transaction log backup will be .trn...
all the best bye...