SQL Server Performance Forum – Threads Archive

setup db in wrong partition

When I installed a parallel database up with enterprise eddition, I was in a hurry and did not set my files to the correct partition. ( I installed on the smaller partition )You can stop laughing now. [:I] Is there an easy way out and put them on the larger partition. the
Bugster

You can detach the database using SP_DETACH_DB and re-attach the database with SP_ATTACH_DB by specifying appropriate partition. If not you can use RESTORE DATABASE … WITH MOVE in order to restore the data files into required partition. In any case Books online is the best resource for the information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

great, i will give it a try when they are on hold in the manufacturing area. since this is a pharmaceutical application, data is very important for FDA.
Thank you
by the way, my brain is getting full, with me reading all this stuff within the forum, but feels good… the
Bugster

http://www.databasejournal.com/features/mssql/article.php/2224361 for more information on above tip. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

when I detach and then attach a database, (using the SP) will user and permissions go with db? I searched books online and did not see info on this one
the
Bugster

Yes all the information and privileges with the database will be stored and depending upon the logins existence on the target server those will work over. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>