Posted by debian mojo on 09/30/95 11:19

1. First detach the db using as :
sp_detach_db <db-name>

2. And place all your files using windows explorer or the command prompt
utility to the locations of your choice.

3. Then attach the db using as :
sp_attach_db <db-name>,<path and file1>,<path and file2>,....,<path
and file16>

If you are using more than 16 files use CREATE DATABASE statement
using the FOR ATTACH option.

That will be enough!

Regards
Debian

*** Sent via Developersdex http://www.developersdex.com ***

[Back to original message]