CODEWITHSUNDEEP
sql-server-2008
Aneesh
Aneesh

Reputation: 21

How to Rename a Database without losing data?

HEllo All, I am in a problem in my sql database.I have a DB in sql 2005.I just want to rename that DB and want it in sql 2008 without losing its data.For examble,i have a mdf and a ldf file of a DB named "Hello" in sql 2005 with a 1000 data,i want to save this DB in sql 2008 in another name "HAi".Anybody please help me.......

Upvotes: 0

Views: 997

Answers (2)

Sonamor
Sonamor

Reputation: 231

I used to have similar errors too, when something like this used to pop up I just simply closed the services of the SQL server and restart it. Then I could do the rename and other stuff for a little while before the error showing up again.

Upvotes: 0

Dave Markle
Dave Markle

Reputation: 97671

Just go into SQL Server Management Studio, select the database, and press F2.

Upvotes: 2

Related Questions