sql server new users: I want to move a copy of a database (bak file) to my local machine so I can
have access to the data offline.

My goal can be thought of as copying a database, data and structures, to my
local machine.

How do I do that? Do I restore it? When I try to restore it using Enterprise
Manager, I see no obvious option that lets me do what I want to do. That
wizard seems intent only on allowing me to restore into a pre-existing
database, which I don't have yet.

How can I do this?

thx
Sql server 2000

[quoted text, click to view]
Hi

You just restore the .bak file on your PC. When you restore using
enterprise manager, you just type in the name you want the new database
to have and then you select your .bak file to restore from.


--
Regards
Steen Schlüter Persson

Thanks! that worked a treat.

[quoted text, click to view]
CRT## wrote:=20
I want to move a copy of a database (bak file) to my local machine so I =
can
have access to the data offline.

My goal can be thought of as copying a database, data and structures, to =
my
local machine.

How do I do that? Do I restore it? When I try to restore it using =
Enterprise
Manager, I see no obvious option that lets me do what I want to do. That
wizard seems intent only on allowing me to restore into a pre-existing
database, which I don't have yet.

How can I do this?

thx
Sql server 2000



Hi

You just restore the .bak file on your PC. When you restore using =
enterprise manager, you just type in the name you want the new database =
to have and then you select your .bak file to restore from.


--=20
Regards
Steen Schl=FCter Persson