Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
largetrousers
Starting Member
3 Posts |
 Posted - 2007-09-11 : 05:44:07
|
HiIm new to this forum so go easy!Ive been asked to do a few things:1. copy an existing 2005 express db to another machine2. on the new machine install 2005 express and get the db working3. upgrade 2005 express to 2005 standard (have disks etc)So far i've physically copied the .mdf and the .ldf to the new local machine and I think ive installed sql 2005 express ok, but what do I do when I start it up, eg asks for a server name etc. Is that my local machine name, ive tried browsing and cant seem to do so locally to pick up the copied db. Once ive got this sorted, is the upgrade to standard a straight forward microsoft install, or do i have to do anything to the db (unmount is it called?)Any help/suggestions would be greatly appreciated! Many thanks  |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-11 : 05:52:21
|
| 1. Would be better to make a Backup, and then Restore that on the new machine. If you must copy the MDf/LDF files make sure you copy them ONLY after the SQL Server has been shut down normally, otherwise the database will not be in a consistent state when you mount it on the new machine (you will have to mount it on the new machine using the ATTACH process - see Books OnLine for more details)3. If this is a machine that does not currently have any databases installed I would do a fresh install of 2005 Standard, and then Restore the database(s) from backup.Note that once you have Copied a database to a new server you have to sort out the "orphaned users" - Database Users map to the Server Login ID, and the IDs numbers allocated vary from server to server.See:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Fix%20Orphaned%20Users,RESTORE%20syntax%20/%20example,Backup,RestoreKristen |
 |
|
|
largetrousers
Starting Member
3 Posts |
Posted - 2007-09-11 : 09:03:21
|
| thanks for all of that. However im still struggling to actually get into sql server to do anything - its installed (express), but on the connect to server page I cannot browse to my local machine (where ive copied db). Tried manually just putting computer name, no joy either. I can browse ok to network sql servers elsewhere on the network. Am I doing something really silly? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-11 : 09:58:25
|
| "Am I doing something really silly?"Doesn't sound like it!"I cannot browse to my local machine (where ive copied db)"Have you installed (express), or is that on another machine? The MDF/LDF files need to be on the same machine that SQL Server is installed on. You then need to use the "ATTACH" method to get SQL Server to use the new files.If you are still struggling I recommend making a Backup file on the original server, and Restoring it on the new server.Kristen |
|
|
|
largetrousers
Starting Member
3 Posts |
Posted - 2007-09-11 : 11:51:18
|
| Im referring to the very first screen you get when firing up sql server management studio express, which says:server type (greyed out - database engine)server name (if I browse here I cannot find local machine or manually put it in, but can see network sql servers)authentication - windowsusername (greyed out - domain\myusername)password (greyed out - blank)once I know how to get past this im sure thanks to your help I can crack on with things - any suggestions? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-11 : 23:13:01
|
| Go to registered servers page in ssms and register your local instance. |
|
|
|
|
|
|
|
|
moving a db and upgrading