"B-Dog" <bdog4@hotmail.com> wrote in message
news:en#2s2NfFHA.3916@tk2msftngp13.phx.gbl...
> I'm using Web Data Administrator to backup/restore some database to move
to
> a new server but when I try and restore on a new server I get the
following
> error? Any ideas? Thanks
>
>

"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:3igeh7Fkhns3U1@individual.net...
> hi,
> B-Dog wrote:
> > I'm using Web Data Administrator to backup/restore some database to
> > move to a new server but when I try and restore on a new server I get
> > the following error? Any ideas? Thanks
> >
> > Line 1: Incorrect syntax near 'O'.
>
> can you please post the entire statement you execute to restore?
> BTW, did you consider the WITH MOVE option required when the destination
> file system folder is not the same as the original ( if the original file
> was on C:\...\file.mdf and the destination is now D:\...\file.mdf)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
>

"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:3iggddFlkdnkU1@individual.net...
> hi,
> B-Dog wrote:
> > I was using wed data administrator so I don't see the statement. I
> > think I got it all done using access, would have liked to use the web
> > data though. I'll look at the paths. Thanks
> >
>
> I actually do no see a BACKUP/RESTORE feature in WDA... (perhaps mine is
> little old :D )... I only see "Import" and "Export" features, that
creates
> a file including DDL create statements for the original db objects and
> data... that file can be later execued to recreate the very same database
> (and objects)...
> it contains a statement like
> CREATE DATABASE [a] ON (NAME = N'a', FILENAME = N'C:\Program
> Files\Microsoft SQL Server\MSSQL\Data\a.mdf' , SIZE = 1, FILEGROWTH = 10%)
> LOG ON (NAME = N'a_log', FILENAME = N'C:\Program Files\Microsoft SQL
> Server\MSSQL\Data\a_log.LDF' , FILEGROWTH = 10%)
>
> and the path can be the offending value if not available on the
destination
> server...
> just a guess
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
>

B-Dog wrote:
> I'm using Web Data Administrator to backup/restore some database to
> move to a new server but when I try and restore on a new server I get
> the following error? Any ideas? Thanks
>
> Line 1: Incorrect syntax near 'O'.

B-Dog wrote:
> I was using wed data administrator so I don't see the statement. I
> think I got it all done using access, would have liked to use the web
> data though. I'll look at the paths. Thanks
>

B-Dog wrote:
> Ah so I guess I was trying to do something that I could. Makes sense
> now. Thanks