Beginning question about coping/moving a sql database

[breckj]

First, I consider myself a novice in Mssql. I've recently began the revision of a website that uses MS Sql Server 2000. In a effort to set up a working environment on my pc, I asked to get a copy of the sql server database. The response was something like "I'm not going to do that!" or "that's too much effort" which left me baffled. Furthermore, the size of the database shouldn't be the issue.

In Access all that is needed is the .mdb file to copy a database. In Sql Server is it that more complicated? My questions are as follows

How does someone copy a sql server database to another pc?
Were they expecting that I remotely test with Sql Server? Is that possible or practical? Isn't it prefered to have the db localized?

Thanks sincerely,
Breck

[ck9663]

First, I consider myself a novice in Mssql. I've recently began the revision of a website that uses MS Sql Server 2000. In a effort to set up a working environment on my pc, I asked to get a copy of the sql server database. The response was something like "I'm not going to do that!" or "that's too much effort" which left me baffled. Furthermore, the size of the database shouldn't be the issue.

In Access all that is needed is the .mdb file to copy a database. In Sql Server is it that more complicated? My questions are as follows

How does someone copy a sql server database to another pc?
Were they expecting that I remotely test with Sql Server? Is that possible or practical? Isn't it prefered to have the db localized?

Thanks sincerely,
Breck

1. How to copy db....You backup your database. copy that backup file and restore it on wherever host you want your db.

2. Where they expecting...? You have to ask them.

3. Possible or practical? Possible, yes. Practical, depends on your existing corporate environment.

4. Preferred to have a local db? As a golden rule and if you guys can afford is, yes it is recommended to have a local db. However, some enterprise setup just configure a testing & development environment within their current network/server setup in order to handle these requirements.