Good morning all,
I have a problem with sql server backup. I am very newbie in sql server
and I would like to backup my database simply.
I went to my database and I clicked with the right button of mouse and
I choose the option backup databases then I choose the full backup and
I add a location in E:/MsSQL/Backup/ (database) everything ok but when
I pressed ok I had this error message:
THE VOLUME ON DEVICE E:/MSSQL/BACKUP/20060501MYDATA/IS NOT PART OF
MULTIPLE FAMILY MEDIA SET BACKUP WITH FORMAT CAN BE USED TO FORM NEW
MEDIA SET. DATABASE IS TERMINATING ABNORMALLY.
THIS IS THE SQL SCRIPT:
BACKUP DATABASE [PORTFOLIO] TO [MYDATADISK] WITH NOINIT , NOUNLOAD ,
NAME = N'MYDATA backup', NOSKIP , STATS = 10, NOFORMAT
I do not know how to do? Could someone help me in this topic?
InaSorry I am in the wrong group
Ina :)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment