>What is the best and fastest way to relocate a database? I’m using SQL7. The data is currently located in the default SQL directory. I need to move it to a larger local drive..
1. sp_detach_db 'mydatabase'
2. Move the database
3. sp_attach_db 'mydatabase','myfilename'
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao