May 16, 2009 at 5:12 am
My user data is currently stored in master.mdf.I have plan to create new user db named as North on same server then migrate the data.The user db (North) that was migrated will be backup before reinstall the SQL 2000 or rebuilt the master file.My question is can i do this way to refresh the master file ....
May 16, 2009 at 8:26 am
I would just migrate the data out of master and then remove it after your application is back online. No need to rebuild the master database - rebuildm is a little klugey and hard to use anyway, and is for corruption I believe. I would probably opt for removing the user objects out and then doing an upgrade rather than otherwise.
May 16, 2009 at 11:54 am
Hello,
I just wanted to check if my understanding is correct – are you planning to separate the user data into its own DB and upgrade to SQL 2005 at the same time? If so, are you planning on a side-by-side or in-place upgrade to SQL 2005?
If that is the case and you moved the user data and then do a side-by-side upgrade, you would end up with a clean Master DB, without any extra work.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
May 18, 2009 at 1:32 am
Thanks for advised....
Currently i'm using SQL 2000.Yes,i plan to separate data into its own DB.How can i refresh the master file if i wanted to use same SQL engine?or can i get the master file from the others SQL engine with same version.
pls help ....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply