dbs on different physical drives

  • Hi, I've been browsing this site for a while, never actually posted. I'm a software developer and I dont know much about the architecture and administration of SQL Server. We are currently using SQL server with all of the dbs on the same physical harddrive and we were wondering if it were possible to separate them on two physical drives. Can anyone give me any advice on how to do this, if it is possible and/or point me to some reading material. Thanks.


    Deborah

  • Sure. Easiest way is to detach/attach. Look at sp_detach_db and sp_attach_db in Books Online (the SQL help file).

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply