Backup database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Backup database

Backup database

Rate Topic

Display Mode

Topic Options

Author

Message

sqlfriends

Posted Tuesday, October 09, 2012 9:59 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 5:40 PM
Points: 1,631, Visits: 2,834

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

BrainDonor

Posted Tuesday, October 09, 2012 10:15 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, June 14, 2013 8:33 AM
Points: 1,402, Visits: 6,950

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

Post #1370471

sqlfriends

Posted Tuesday, October 09, 2012 10:21 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 5:40 PM
Points: 1,631, Visits: 2,834

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

davidwarner

Posted Tuesday, October 09, 2012 4:15 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, January 24, 2013 2:06 PM
Points: 19, Visits: 72

Maybe you should engage the vendor that set it all up to find out why they have set it up that way?

Post #1370606

sqlfriends

Posted Tuesday, October 09, 2012 4:21 PM

SSCommitted

Group: General Forum Members
Last Login: Today @ 5:40 PM
Points: 1,631, Visits: 2,834

I found this is a logical backup device,
We have to drop it first then recreate it with different path.

Thanks

Post #1370609

Perry Whittle

Posted Wednesday, October 10, 2012 1:37 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:58 PM
Points: 5,242, Visits: 11,259

sqlfriends (10/9/2012)

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" Wink

Post #1370739

« Prev Topic | Next Topic »

Permissions