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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Express: duplicate, rename and copy a database

Author  Topic 

gioloi
Starting Member

1 Post

Posted - 2008-06-18 : 12:24:01
Hi,
first of all escuse my English. I'm new to SQL Server, my experience is with MySQL, Interbase and Firebird, but now I have a new job so I need to use SQL Server, version 2005 Express.
I have two SQL 2005 Express installations in two different machines (local and remote). I can access both servers via SQL Management Studio
I need to do the following:
1) Create a copy of a database with a new name in the same machine (local).
2) Copy the new renamed database to another host (remote)
Please help me, remember I use Express edition.

Thanks in advance.

Giorgio

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-18 : 15:55:46
Did you check backup/restore in Booksonline?
Go to Top of Page
   

- Advertisement -