February 22, 2008 at 9:58 am
I currently have about 4 databases on our SAN located in one of the drives. These databases are going to expand massively and I want o seperate 1 onto seperate drives located on the SAN. I figured using SQL Server Management Studio I could complete this with an easy "Detach / Attach" operation. When I go to attach the files back into SQL, it doesn't read any other drive other than the current drive all of the databases are located on.
Is there a way to do this?
February 22, 2008 at 12:15 pm
try detaching the database and then move the files and try sp_attach_db stored procedure to attach the files.
February 24, 2008 at 11:39 am
My guess is that you are on a cluster. The drives have been added to the cluster, but not so that SQL Server can see them. On a cluster, you have to make SQL Server dependent upon the new drives before SQL Server can see them.
If this is the case, the process is:
1) Stop SQL Server using Cluster Administration
2) Modify the dependencies on SQL Server, adding the new drives
3) Restart SQL Server using Cluster Administration
4) Detach database(s)
5) Copy files to new locations
6) Attach database(s)
HTH,
Jeff
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 24, 2008 at 1:58 pm
I'd go with Jeff's reply !
Also make sure the sqlserver service account has the needed rights to
the new drives and folders !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply