Hello, I'm trying to do a backup of a database by creating a job for it....
I'm entering the command but when I do a Parse to ensure that the syntax is
correct, I'm getting the following error:
"TITLE: Parse Command Text
The following errors were detected in the command text.
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The identifier that starts with 'EXEC sp_addumpdecive 'disk',
'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
backup database WSS_Content to back' is too long. Maximum length is 128.
(Microsoft SQL Server, Error: 103)"
Is that because of the location(
'\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the backup
to?
Please help.....
Thanks
Shelly
Run in the job's step
BACKUP DATABASE dbname TO DISK =
N'\\Server\folder\dbname.BAK'
"Shelley" <Shelley@.discussions.microsoft.com> wrote in message
news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
> Hello, I'm trying to do a backup of a database by creating a job for
> it....
> I'm entering the command but when I do a Parse to ensure that the syntax
> is
> correct, I'm getting the following error:
> "TITLE: Parse Command Text
> --
> The following errors were detected in the command text.
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The identifier that starts with 'EXEC sp_addumpdecive 'disk',
> 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
> backup database WSS_Content to back' is too long. Maximum length is 128.
> (Microsoft SQL Server, Error: 103)"
> Is that because of the location(
> '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
> backup
> to?
> Please help.....
> Thanks
>
|||HI, ,thank you so much it worked.....
But I would like to know, what is the purose of the "N"?
Also, If i want to overwrite the backup, what do I need to include in the
command?
"Uri Dimant" wrote:
> Shelly
> Run in the job's steps
> BACKUP DATABASE dbname TO DISK =
> N'\\Server\folder\dbname.BAK'
>
> "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
>
>
|||Hi, thank you it worked.
However I would like to know what is the purpose of the "N"?
Also, If i want to overwrite the backup, what exactly do I need to include
in the command?
"Uri Dimant" wrote:
> Shelly
> Run in the job's step
> BACKUP DATABASE dbname TO DISK =
> N'\\Server\folder\dbname.BAK'
>
> "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
>
>
|||Shelley
1) You do not have to use N.
http://support.microsoft.com/kb/239530
2) Use WITH INIT option of the BACKUP DATABASE command
"Shelley" <Shelley@.discussions.microsoft.com> wrote in message
news:6E0ED4AC-38AA-41C6-916A-E752D62185EF@.microsoft.com...[vbcol=seagreen]
> HI, ,thank you so much it worked.....
> But I would like to know, what is the purose of the "N"?
> Also, If i want to overwrite the backup, what do I need to include in the
> command?
> "Uri Dimant" wrote:
|||Hi, thanks alot..... it worked.
"Uri Dimant" wrote:
> Shelley
> 1) You do not have to use N.
> http://support.microsoft.com/kb/239530
> 2) Use WITH INIT option of the BACKUP DATABASE command
>
> "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> news:6E0ED4AC-38AA-41C6-916A-E752D62185EF@.microsoft.com...
>
>
|||N makes the string Unicode.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Shelley" wrote:
[vbcol=seagreen]
> Hi, thank you it worked.
> However I would like to know what is the purpose of the "N"?
> Also, If i want to overwrite the backup, what exactly do I need to include
> in the command?
> "Uri Dimant" wrote:
|||Thank you
"Mohit K. Gupta" wrote:
[vbcol=seagreen]
> N makes the string Unicode.
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
> "Shelley" wrote:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment