Database Backup

Hi,
I have been sent a SQL .bak file by email which I am trying to create onto a
new SQL Server running SQL Server 2003, this backup file was not from the
server that I am trying to set it up on. All seemed ok with the first part
of the installation, and I told SQL server to put the mdf and ldf files in
the default Data directory on the Server but then I got the following message
File
C:\Program Files\Microsoft SQL Server\MSSQL\Data is claimed by Log(1) and
Data(2). The With Move clause can be used to relocate one or more files,
Restore Database is terminating abnormally.
And then nothing happens, can someone tell me what this means or what I am
doing wrong.
Any help is muc appreciated
Hi
You may want to profile to see the command being executed, or just try the
restore from a query window.
John
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:06AB742F-9B29-44CD-B514-EFAD6C2E7A1A@.microsoft.com...
> Hi,
> I have been sent a SQL .bak file by email which I am trying to create onto
> a
> new SQL Server running SQL Server 2003, this backup file was not from the
> server that I am trying to set it up on. All seemed ok with the first
> part
> of the installation, and I told SQL server to put the mdf and ldf files in
> the default Data directory on the Server but then I got the following
> message
> File
> C:\Program Files\Microsoft SQL Server\MSSQL\Data is claimed by Log(1) and
> Data(2). The With Move clause can be used to relocate one or more files,
> Restore Database is terminating abnormally.
> And then nothing happens, can someone tell me what this means or what I am
> doing wrong.
> Any help is muc appreciated
|||Phil,
There is no SQL Server 2003. Is this 2000 or 2005? It sounds as if you may
already have a db in that directory with those file names. How are you
restoring this, from the GUI or command?
Andrew J. Kelly SQL MVP
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:06AB742F-9B29-44CD-B514-EFAD6C2E7A1A@.microsoft.com...
> Hi,
> I have been sent a SQL .bak file by email which I am trying to create onto
> a
> new SQL Server running SQL Server 2003, this backup file was not from the
> server that I am trying to set it up on. All seemed ok with the first
> part
> of the installation, and I told SQL server to put the mdf and ldf files in
> the default Data directory on the Server but then I got the following
> message
> File
> C:\Program Files\Microsoft SQL Server\MSSQL\Data is claimed by Log(1) and
> Data(2). The With Move clause can be used to relocate one or more files,
> Restore Database is terminating abnormally.
> And then nothing happens, can someone tell me what this means or what I am
> doing wrong.
> Any help is muc appreciated
|||Hi Andrew,
Srry about that I dont know what I was thinking, it's 2000, I am trying to
restore it using the GUI, thanks!
Phil
"Andrew J. Kelly" wrote:

> Phil,
> There is no SQL Server 2003. Is this 2000 or 2005? It sounds as if you may
> already have a db in that directory with those file names. How are you
> restoring this, from the GUI or command?
> --
> Andrew J. Kelly SQL MVP
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:06AB742F-9B29-44CD-B514-EFAD6C2E7A1A@.microsoft.com...
>
>
|||Please ignore this post, I was doing something really stupid which I
embarassed to tell the public.
Thanks for taking the time to check the post anyway.
Thanks Phil
"Phil" wrote:

> Hi,
> I have been sent a SQL .bak file by email which I am trying to create onto a
> new SQL Server running SQL Server 2003, this backup file was not from the
> server that I am trying to set it up on. All seemed ok with the first part
> of the installation, and I told SQL server to put the mdf and ldf files in
> the default Data directory on the Server but then I got the following message
> File
> C:\Program Files\Microsoft SQL Server\MSSQL\Data is claimed by Log(1) and
> Data(2). The With Move clause can be used to relocate one or more files,
> Restore Database is terminating abnormally.
> And then nothing happens, can someone tell me what this means or what I am
> doing wrong.
> Any help is muc appreciated
|||It happens to all of us from time to time.
Andrew J. Kelly SQL MVP
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:D9FA646E-D31A-46EE-ADC7-CF4E29988C8A@.microsoft.com...[vbcol=seagreen]
> Please ignore this post, I was doing something really stupid which I
> embarassed to tell the public.
> Thanks for taking the time to check the post anyway.
> Thanks Phil
> "Phil" wrote: