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 |
archintel
Starting Member
1 Post |
Posted - 2005-12-20 : 22:02:11
|
i need help moving a database to a new server.I have an existing database on a Windows XP Pro box running MS SQL Server Desktop Engine 8.00.I want to move this database to another machine running Windows Server 2003 Small Business Server w/full SQL Server (new edition).I can see the database, and the directory structures are almost identical on both machines. But when I simply copy the data over nothing works. Obviously to me I must somehow back up the original database and restore it somehow on the new machine.Any tips on where I begin? I have done searches in the Microsoft Knowledgebase for articles on how to backup and restore from one type SQL to another with frustrating results. No clear directions.Thanks! |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-12-23 : 06:21:26
|
hi,and dont miss to read :http://vyaskn.tripod.com/moving_sql_server.htm:-)RegardsAndy DavisActivecrypt Team--------------------------------------------SQL Server Encryption Softwarehttp://www.activecrypt.com |
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
|
|
|
|