Copying a subset from SQL Server

Newbie question: (apologies all)
How does one download a subset from server to notebook?
Practical problem: Executive visiting customer wants database on customer.
Sharepoint and Project 2003 data.
Thank you
Brent Rowell
"Brent Rowell" <anonymous@.discussions.microsoft.com> wrote in message
news:D4B70D84-AA6E-4B1E-929C-C9F7C770B84B@.microsoft.com...
> Newbie question: (apologies all)
> How does one download a subset from server to notebook?
> Practical problem: Executive visiting customer wants database on customer.
> Sharepoint and Project 2003 data.
Once you've got MSDE installed on the laptop, you could use Enterprise
Manager and DTS to transfer the data subset you need from the server to the
notebook...
Steve
|||Thank you
Brent
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:O0WrUcMIEHA.828@.TK2MSFTNGP12.phx.gbl...
> "Brent Rowell" <anonymous@.discussions.microsoft.com> wrote in message
> news:D4B70D84-AA6E-4B1E-929C-C9F7C770B84B@.microsoft.com...
customer.
> Once you've got MSDE installed on the laptop, you could use Enterprise
> Manager and DTS to transfer the data subset you need from the server to
the
> notebook...
> Steve
>
|||"Brent Rowell" <brent@.pls_remove_jrowell.com> wrote in message news:<eEYV2wPIEHA.3200@.TK2MSFTNGP10.phx.gbl>...[vbcol=seagreen]
> Thank you
> Brent
> "Steve Thompson" <SteveThompson@.nomail.please> wrote in message
> news:O0WrUcMIEHA.828@.TK2MSFTNGP12.phx.gbl...
> customer.
> the
You could use Super*SQL to create an ASCII file containing all of the
database tables, then copy the file to the notebook and load into the
local database. I found the Beta version at www.sqlmagic.com.

Copying .MDF & .LDF files for new server

Hello - I am trying to copy a database file from our existing server into an FTP site so I can download and then upload to a new server. When using the file explorer and copy command I recieve an error that the states

" Cannot copy ***data file: It is being used by another person or program, close any programs that might be using the file and try again"

I have stopped MS SQL, stopped IIS etc - ANY SUGGESTIONS?

VinceDetach the database before trying to copy it.|||

Quote:

Originally Posted by seniorinsight

Hello - I am trying to copy a database file from our existing server into an FTP site so I can download and then upload to a new server. When using the file explorer and copy command I recieve an error that the states

" Cannot copy ***data file: It is being used by another person or program, close any programs that might be using the file and try again"

I have stopped MS SQL, stopped IIS etc - ANY SUGGESTIONS?

Vince

Use the Backup tool from Enterprise manager. Copy and load the backup on your new server. This is the proper way to transfer databases.