JaysonJackson
asked on
backup up MS-SQL 2005 Error
We have a Microsoft 2003 server running MS-SQL2005. I am trying to create a job for backing up the database. Here are the job Properties
General.
Name: Daily Backup
Owner = server name\Administrator
Category: Database Maintenance.
Steps
Name = step1
Type Transact-SQL script (T-SQL)
Run as [empty]
Database = LFPBS8
Command =
EXECUTE master.dbo.xp_create_subdi r N'D:\Backup\LFPBS8'
GO
BACKUP DATABASE [LfPBS8] TO DISK = N'D:\Backup\LFPBS8'LFPBS8_ backup.bak ' WITH NOFORMAT, INIT, NAME = N'LFPBS8_backup', SKIP, REWIND, NOUNLOAD, STATS = 10
Database is LFPBS8
Backing up to d:\backup\LFPBS8
Here is the log (by looking at this I am sure I left a quote out but were?)
01/29/2010 09:33:06,daily backup,Error,0,PHX-SERVER0 1,daily backup,(Job outcome),,The job failed. The Job was invoked by User PHX-SERVER01\Administrator . The last step to run was step 1 (step1).,00:00:01,0,0,,,,0
01/29/2010 09:33:06,daily backup,Error,1,PHX-SERVER0 1,daily backup,step1,,Executed as user: PHX-SERVER01\_Service_SQL_ Agent. Incorrect syntax near '.'. [SQLSTATE 42000] (Error 102) Unclosed quotation mark after the character string '<c/> SKIP<c/> REWIND<c/> NOUNLOAD<c/> STATS = 10 '. [SQLSTATE 42000] (Error 105). The step failed.,00:00:01,15,105,,, ,0
General.
Name: Daily Backup
Owner = server name\Administrator
Category: Database Maintenance.
Steps
Name = step1
Type Transact-SQL script (T-SQL)
Run as [empty]
Database = LFPBS8
Command =
EXECUTE master.dbo.xp_create_subdi
GO
BACKUP DATABASE [LfPBS8] TO DISK = N'D:\Backup\LFPBS8'LFPBS8_
Database is LFPBS8
Backing up to d:\backup\LFPBS8
Here is the log (by looking at this I am sure I left a quote out but were?)
01/29/2010 09:33:06,daily backup,Error,0,PHX-SERVER0
01/29/2010 09:33:06,daily backup,Error,1,PHX-SERVER0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER