Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup database Expand / Collapse
Author
Message
Posted Tuesday, October 9, 2012 9:59 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 18, 2014 4:41 PM
Points: 1,770, Visits: 3,202
We have a SQL server that hosts a vendor product.
The vendor setup a backup for the database.

I see in the SQL job it has a T-SQL
BACKUP DATABASE [RenaissanceServer] TO [RenaissanceServer] WITH INIT , NOUNLOAD , NAME = N'RenaissanceServer backup', NOSKIP , STATS = 10, NOFORMAT

What does this mean?

I thought after the word TO it has to be device name, but this one is the database name, what this means?

Thanks
Post #1370464
Posted Tuesday, October 9, 2012 10:15 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:42 AM
Points: 1,541, Visits: 8,197
It is entirely possible that a backup device has been created with the same name as the database.

Does that name appear within sys.backup_devices?


BrainDonor
Linkedin
Blog Site
Post #1370471
Posted Tuesday, October 9, 2012 10:21 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 18, 2014 4:41 PM
Points: 1,770, Visits: 3,202
Thanks,

I got this:
name type type_desc physical_name
RenaissanceServer 2 DISK E:\MSSQL\DataRenaissanceServer.bak
RenaissanceServer_LOG 2 DISK E:\MSSQL\DataRenaissanceServer_log.bak
MASTER_MSDB 2 DISK E:\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,
Post #1370474
Posted Tuesday, October 9, 2012 4:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, December 8, 2013 10:48 PM
Points: 31, Visits: 124
Maybe you should engage the vendor that set it all up to find out why they have set it up that way?
Post #1370606
Posted Tuesday, October 9, 2012 4:21 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 18, 2014 4:41 PM
Points: 1,770, Visits: 3,202
I found this is a logical backup device,
We have to drop it first then recreate it with different path.

Thanks
Post #1370609
Posted Wednesday, October 10, 2012 1:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:39 AM
Points: 6,294, Visits: 13,572
sqlfriends (10/9/2012)
Thanks,

I got this:
name type type_desc physical_name
RenaissanceServer 2 DISK E:\MSSQL\DataRenaissanceServer.bak
RenaissanceServer_LOG 2 DISK E:\MSSQL\DataRenaissanceServer_log.bak
MASTER_MSDB 2 DISK E:\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"
Post #1370739
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse