SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Classes
About Us
Login / Register
Subscribe RSS Feed 

Download a free trial of SQL Backup now

Renaming a Database

You won't do it often, but it's nice to know how, and you're not still using sp_renamedb are you? Join us for a quick look at how to use the alter syntax to change the db name along with a tip on how to quickly disconnect any remaining users from the database.

Duration:
2 mins 13 secs
Skill Level:
100
Rating:
4.37 out of 5
Publish Date:
March 09, 2010
Renaming a Database Watch Video Now  Watch it later!
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Andy Warren
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

References

There are no downloads or recommended reading links for this video

Comments
Nihar Panda on 3/10/2010
sure...a good one clean and nice one

Famson on 3/10/2010
Concise and valuable. Nice material, nice presentation.

Don on 3/10/2010
Your comment at the end answered a question that I had concerning the DB files and what happens to them when I rename a DB. It would be nice if the DB files could be renamed at the same time but I suppose that would require an offline process. Thanks for this tip!

Laurence Ossler on 3/10/2010
nice and easy

Martin Miller on 3/10/2010
Thanks Andy

Leonard Peoples on 3/10/2010
Very helpful. Keep 'em coming. Thanks a bunch.

luther smith on 3/10/2010
Simple, straightforward.

Christian Bahnsen on 3/10/2010
I've never had to rename a database but thanks for showing how

Andre on 3/10/2010
Thank you

Travis on 3/11/2010
It's not quite that simple. Andy is good, but he tends to leave out a lot of important considerations in his videos. On big one is you must evaluate all code beforehand in that database, other databases on that server, as well as other linked servers that are referring to the old database name...Otherwise, lots of things will start to break and you will get tons of phone calls...trust me on this guys..

Marco A. Vera Ch. on 3/12/2010
Thanks

Lloyd Edwards on 3/13/2010
thanks!

Hussein on 3/15/2010
thanks

Carla Wilson on 4/1/2010
Thank you! I got a great idea for a problem I was having by using the Single_user technique! Also, I would have liked to see you demonstrate how to detach and rename the files.

James on 5/12/2010
Great I like it, thank you.

abdul samath on 5/30/2010
useful one

770B330898 on 6/25/2010
nice to know



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions