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?
InaHi Ina
Did you use the Database Backup Wizard to do this? In which case you need to
remove any files that are already specified as backup files bafore adding
your new file. You may have specified the backup file incorrectly it should
be something like E:\MsSQL\Backup\20060501MYDATA.dmp i.e. give it a filename
.
HTH
John
"ina" wrote:
> 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 , NOUNLO
AD ,
> NAME = N'MYDATA backup', NOSKIP , STATS = 10, NOFORMAT
>
> I do not know how to do? Could someone help me in this topic?
>
> Ina
>|||thanks but I create a backup device as E:/MSSQL/BACKUP/MYDATADISK.bak/
BACKUP DATABASE [PORTFOLIO] TO [MYDATADISK] WITH NOINIT , NOUNLOAD
,
NAME = N'MYDATA backup', NOSKIP , STATS = 10, NOFORMAT ... it is
correct? Seems that works...and what is the difference between .bak
and .dmp it is for dump.
Could you explain me a little more, I am sorry to be so newbie but I am
afraid to incorrect tasks in sql server.
Thanks a lot
Ina|||Hi
You can name the file anything you like, the extension is not mandatory
although I am not sure why you have a '/' at the end of your device?
The backup command was previously DUMP before SQL Server Version 7.0 hence
sp_adddumpdevice is the stored procedure that will create the backup device.
HTH
John
"ina" wrote:
> thanks but I create a backup device as E:/MSSQL/BACKUP/MYDATADISK.bak/
> BACKUP DATABASE [PORTFOLIO] TO [MYDATADISK] WITH NOINIT , NOUNLO
AD ,
> NAME = N'MYDATA backup', NOSKIP , STATS = 10, NOFORMAT ... it is
> correct? Seems that works...and what is the difference between .bak
> and .dmp it is for dump.
>
> Could you explain me a little more, I am sorry to be so newbie but I am
> afraid to incorrect tasks in sql server.
> Thanks a lot
> Ina
>|||hello John;
I created a backup device (disk) with entreprise manager; it is the
same as sp_addumpdevice and if I would like to create a device using
this sp how can I do it?
Ina|||> I created a backup device (disk) with entreprise manager; it is the
> same as sp_addumpdevice
Yes.
> and if I would like to create a device using
> this sp how can I do it?
sp_addumpdevice is documented in the product documentation (Books Online). H
ere you find what
parameters you specify along with examples.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1146553855.811297.184500@.y43g2000cwc.googlegroups.com...
> hello John;
> I created a backup device (disk) with entreprise manager; it is the
> same as sp_addumpdevice and if I would like to create a device using
> this sp how can I do it?
> Ina
>|||Thanks a lot
Ina :D
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment