Re: restore error


thanks.. figures it was something stoopid ;)

"Hari Prasad" wrote:

> Hi,
>
> Try this:-
>
> restore database shopblue from disk='d:\blue\shopblue_db_200508260305.BAK'
> with Move 'TESFLOW' to 'C:\Program Files\Microsoft SQL
> Server\MSSQL\Data\shopblue_Data.mdf',
> Move 'TESFLOW_Log' to 'C:\Program Files\Microsoft SQL
> Server\MSSQL\Data\shopblue_Log.ldf',replace
>
>
> Note:
>
> There will be space in Microsoft SQL Server folder. Looks like u missed that
> space between SQL and Server. And there is no need of double quotes (")
>
> Thanks
> Hari
> SQL Server MVP
>
> "Dabbler" <Dabbler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:B01E4AC4-E840-47F8-A455-2F35DF13D5AB@xxxxxxxxxxxxxxxx
> > when using osql to restore a database from one server to a local MSDE
> >
> > restore database shopblue from disk='d:\blue\shopblue_db_20050
> > 8260305.BAK' with Move 'shopblue_Data' to '"C:\Program Files\Microsoft
> > SQLS
> > erver\MSSQL\Data\shopblue_Data.mdf"', Move 'shopblue_Log' to '"C:\Prog
> > ram Files\Microsoft SQLServer\MSSQL\Data\shopblue_Log.ldf"',replace
> >
> > I get the following error when trying to restore to the default SQL data
> > folder:
> >
> > Msg 5105, Level 16, State 2, Server SONATA, Line 1
> > Device activation error. The physical file name 'C:\Program
> > Files\Microsoft
> > SQLServer\MSSQL\Data\shopblue_Data.mdf' may be incorrect.
> >
> > However when I use another folder say:
> > ... with Move 'shopblue_Data' to 'd:\blue\web\db\shopblue
> > _Data.mdf', Move 'shopblue_Log' to
> > 'd:\blue\web\db\shopblue_Log.ldf',replace
> > that works fine.
> >
> > Can anyone clarify the syntax required to install the db in the default
> > folder? I suspect is has something to do with spaces in name of the
> > folder.
> >
> > Thanks for any assistance
>
>
>
.

Relevant Pages

  • install/configure SQL Server 2000, SQL Server CE for merge replica
    ... connect to the database from a Pocket PC 2002 emulator. ... Initializing SQL Server Reconciler has failed ... SQL Server does not exist or access denied OR Login Failed for user ... Create Snapshot folder steps: ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL Server 2005 setup failed: SQL service failed to start
    ... As stated at the end of my post, the folder Protect doesn't exist. ... I can't get SQL 2005 Standard installed on on Intel Xeon system with W2K3 ... The SQL Server log shows this: ...
    (microsoft.public.sqlserver.setup)
  • Re: Replication error at subscribers end
    ... SQL 2000. ... the SQL Server agent account on the subscriber rights to read and list files ... and folders on the share folder and the files and folders underlying it). ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Need more space on C: Drive
    ... If they are SQL or MSDE databases, IIRC there's a procedure for moving them ... I've put as much apps as I know possible on the D & F drives. ... SQL server is installed on the D drive but there still appears to be ... SQL Svr folders in the C:\Program Files folder (1 MS Sql Server & MS SQL ...
    (microsoft.public.windows.server.sbs)
  • RE: ASPNETDB.mdf
    ... An end user instance of a sqlexpress database runs just fine in the app_data ... folder in a website. ... It works fine with sql authentication. ... can't buy a complere SQL server. ...
    (microsoft.public.dotnet.framework.aspnet)