how to configure backup device

[Former Member]

Hii,

I have fresh install 4.7 with sql 2000 database . I want to take backup of my database in other drive . how i will configure this drive .

thanks & regards

jagdish

[Former Member]

hi,

you want to take backup using DB13 or from SQL server enterprise manager,

if you want to take backup on network drive the drive must be map and accessible through windows.

configure backup devices on MS SQL Server management Studio,

logon to SQL server management Studio,

under object explorer navigate through server object -> backup devices

create new backup device -- destination file type. give path for your network drive backup folder.

regards,

kaushal