Posted by debian mojo on 10/01/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 ***

• Next in forum: Re: SQL Server performance problem!
• Prev in forum: Re: VB6/SQL Server application runs locally, but not from server
• Thread view: Re: moving data files to a new disk, same server

[Reply to this message]