Sunday, March 11, 2012

backup database

Hi, Below is my script and when I run it I get following
error. What is causing this error?
Thanks for your help.
BACKUP DATABASE IntelSource TO
DISK = 'C:\SQL\BACKUP\DIFF_IntelSource.BAK'
WITH DIFFERENTIAL
GO
Error Message:
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'DATABASE'.That looks like a valid syntax. Perhaps, 'backup database' is not the first
statement in the batch.
-oj
<oeren@.calcoastcu.org> wrote in message
news:133b01c504ba$56e84d20$a401280a@.phx.gbl...
> Hi, Below is my script and when I run it I get following
> error. What is causing this error?
> Thanks for your help.
> BACKUP DATABASE IntelSource TO
> DISK = 'C:\SQL\BACKUP\DIFF_IntelSource.BAK'
> WITH DIFFERENTIAL
> GO
> Error Message:
> Server: Msg 156, Level 15, State 1, Line 1
> Incorrect syntax near the keyword 'DATABASE'.|||... Or perhaps the database from where the command is executed is in 60 or
65 compatibility mode?
(Assuming BACKUP DATABASE is affected by compatibility mode...)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"oj" <nospam_ojngo@.home.com> wrote in message news:eRlZwDMBFHA.3664@.TK2MSFTNGP14.phx.gbl...

> That looks like a valid syntax. Perhaps, 'backup database' is not the firs
t statement in the
> batch.
> --
> -oj
>
> <oeren@.calcoastcu.org> wrote in message news:133b01c504ba$56e84d20$a401280
a@.phx.gbl...
>|||
Thank you.. That is what I did also.. set compatilibity level to 80.
Thanks again for the reply...
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

No comments:

Post a Comment