sqlfriends (10/9/2012)
Thanks,I got this:
nametypetype_descphysical_name
RenaissanceServer2DISKE:\MSSQL\DataRenaissanceServer.bak
RenaissanceServer_LOG2DISKE:\MSSQL\DataRenaissanceServer_log.bak
MASTER_MSDB2DISKE:\MSSQL\DataMASTER_MSDB.bak
I noticed the vendor didn't put the device to our backup drive which is G:\Backup,
How can I change the device to it?
Thanks,
Use sp_dropdevice to delete the current backup device and recreate it using sp_addumpdevice. Both are detailed in Books Online.
Point out to the vendor that backing up to a dump device with INIT will be overwriting backup sets, do you really want to do this? What is your SLA for "getting the data back"?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉