benito
3rd June 2009, 16:05
Hi,
What do you think is the best way to modify mssql_storage. I'm moving my db to another server and want to do modifications. i have 150 gb MSSQL database. certain big tables need to reside on specific filegroups. I've read that maybe I need to change the default filegroup first before I create a table? which means I need to drop the table first? My original plan was also to use the "force restore" the db as opposed to bdbpre/bdbpost but i think this will switch back my filegrouping? Thanks a lot in advance.
What do you think is the best way to modify mssql_storage. I'm moving my db to another server and want to do modifications. i have 150 gb MSSQL database. certain big tables need to reside on specific filegroups. I've read that maybe I need to change the default filegroup first before I create a table? which means I need to drop the table first? My original plan was also to use the "force restore" the db as opposed to bdbpre/bdbpost but i think this will switch back my filegrouping? Thanks a lot in advance.