Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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, May 16, 2016 11:46 AM
Points: 1,914, Visits: 3,587
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: Tuesday, May 17, 2016 6:12 AM
Points: 1,802, Visits: 10,292
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?


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

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, May 16, 2016 11:46 AM
Points: 1,914, Visits: 3,587
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, April 21, 2016 12:50 AM
Points: 67, Visits: 471
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, May 16, 2016 11:46 AM
Points: 1,914, Visits: 3,587
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Tuesday, May 17, 2016 7:44 AM
Points: 8,111, Visits: 16,284
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