Will any of these options also rename the file sitting beneath the DB? One of our problems in data migration is using a standard DB name for an extract which we want to re-use in each subsequent test conversion but retain the old DB for investigative purposes so we need to rename the old extract db, i.e. Please tell me the steps to rename a database that is configured with database mirroring its urgent please Is there any project, I can do practice in my leasure timeīack To Top - you will need to remove mirroring, rename database and setup mirroring again. What is the diff btween SQL programming and T-SQL programming? Sir, I have joined as a T-SQL Programmer in a startup company, at beginning stage. ![]() I executed below remane db command on sql server 2000 and it works succefully.ĪLTER DATABASE oldName MODIFY NAME = newName Greg Robidoux Thank You very much!!!! short and precise. If I need to rename my DB while it is being accessed by other customers across the world can I use the same method? How can i rename the DB in this case. Thanks for this article, it save me a time after trying several different options within the same server.īack To Top order to rename a database you have to have exclusive access, so you need to get everyone out of the database first. IF DATABASEPROPERTYEX (N'CBA', N'Version') > 0 ![]() ![]() Step 3: Set the DB back in Multi User Mode. IF DATABASEPROPERTYEX (N'ABC', N'Version') > 0 Tuesday, Ma10:59:53 AM - Varney Fahnbulleh ![]() After trying different sites with their explanations, this covered it 100 percent.
0 Comments
Leave a Reply. |