Advertisement

08.08.2007 at 09:39AM PDT, ID: 22749892
[x]
Attachment Details

SQL 2005 Backup Database using T-SQL ServerObjects-->Backup Devices

Asked by yanci1179 in SQL Server 2005, SQL Query Syntax

Tags: , , ,

In SQL 2005 I created a Backup Device that points to the backup location

I this scripted the following:

BACKUP DATABASE Database
TO DISK = N'BackupDeviceName\TrackIT.bak'
WITH Description =N'Full Database Backup'
, INIT
, NAME = N'DatabaseFullBackup'
GO

It doesn't look for the backup in the device.  It is looking for the file in C Drive.  Will I actually have to specify the drive D:\backups or can I use the backup device that I created that is already pointing to the drive?  Since the Maintnance Jobs are not available in SQL 2005, I planned on running the statement in a scheduled job, is this the best way to do this or is there another way in SQL 2005?Start Free Trial
[+][-]08.08.2007 at 10:15AM PDT, ID: 19656117

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.08.2007 at 10:22AM PDT, ID: 19656187

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.09.2007 at 06:37AM PDT, ID: 19662030

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.14.2007 at 04:58PM PDT, ID: 19696406

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, SQL Query Syntax
Tags: backup, 2005, sql, database
Sign Up Now!
Solution Provided By: itdrms
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628