Database

TONYRGATOR
11-19-2002, 11:52 AM
I have a Server at work running Sql server 2000

This Server has 2 hard drives

1 drive has 9 Gb
other has 90 Gb

the one with 9 GB has sql installed

Is there any way, without installing sql on the 90 GB drive,
to save the data on the 90 GB drive.

This Server is used by software I did not build, and my Managers are afraid that if I installed sql 2000 on the second drive
something will go wrong.

jcd
11-19-2002, 04:19 PM
Look into a couple stored procedures:
sp_detach_db
sp_attach_db
sp_attach_single_file_db

I would read up on them before you try anything so that you dont mess anything up.
Regards
jcd

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum