This may help you.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

Vinay

________________________________

From: Brown Dave [mailto:mssqldba-ezmlmshield-x50287958.[Email address protected]
Sent: Thu 9/28/2006 6:45 PM
To: LazyDBA Discussion
Subject: RE: Moving databases



Hi Annette,

The files were moved across from server to laptop on a cd. The
application will be accessed as ' stand alone ' no network issues. The
failure is in the syntax of restore database where there are multiple
filegroups (7 in my case ).
Dave

-----Original Message-----
From: Annette Ehrlich
[mailto:mssqldba-ezmlmshield-x41062053.[Email address protected]
Sent: 28 September 2006 14:06
To: LazyDBA Discussion
Subject: Re: Moving databases

Is there an error or some type of failure? Don't forget that in Windows
XP, you may need to change the firewall settings to enable access to the
SQL port.

Brown Dave wrote:

> PLEASE READ THE IMPORTANT NOTICE BELOW. DO NOT OPEN ANY ATTACHMENT
WITHOUT PRIOR VIRUS CHECKING.
> ________________________________________________________
>
> Greetings All,
>
> I've been wrestling with this problem for a couple of day's now and
> it's really starting to bug me . Any help would be appreciated. :-)
>
> I've a database with a primary file group and six other file groups.
> I'm attempting to move it onto a Laptop so the application can be
> demonstrated to prospective clients.
>
> I've eventually achieved this by copying all mdf files across to the
> laptop and used attach database - yippee.
>
> What's bugging me is that I tried this using the TSQL as found in
> BOL in the 'how to restore files and filegroups under existing files,
> chapter. substituting my database name & filegroups & procreating the
> database & filegroups on the laptop.
>
> Anyone had similar problems ?
>
> Regards
> Dave Brown
>
>
>
> __________________________________________________________________
> Liberata is the trading name of Liberata UK Limited (Registered in
England and Wales - No 1238274) and other Liberata group companies which
include Liberata Financial Services Limited (Registered in England and
Wales - No 5301492), an entity authorised and regulated by the Financial
Services Authority. The holding company is Liberata Limited ( Registered
in England and Wales - No 3987802).
>
> Registered Office: 5th Floor Downstream Building, No. 1 London Bridge,

> London SE1 9AJ
>
> IMPORTANT NOTICE:
> This e-mail (including all attachments) is confidential and may be
privileged. It is for the exclusive use of the intended recipient(s)
only, and must not be re-transmitted in an amended form without our
consent. If you have received it in error, please contact us immediately
at [Email address protected] Please then delete it and do not disclose
its contents to any other person.
>
> Security and reliability of e-mails are not guaranteed. We operate
anti-virus programmes but you must take full responsibility for virus
checking this e-mail (including all attachments). Liberata UK Limited do
not accept any liability in respect of any damage caused by any virus
which is not detected.
>
> All e-mails to and from anyone @liberata.com may be examined for
breaches of employee policies and the law. All e-mails to anyone
@liberata.com are communications to the company and not private and
confidential to any named individual.
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post

> a dba job: http://jobs.lazydba.com To subscribe :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html






DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.

MS Sql Server LazyDBA home page