| Author |
 Topic  |
|
|
pberp
Starting Member
15 Posts |
 Posted - 12/18/2009 : 08:26:17
|
The sql server version both are 6.5.
Is that feasible? |
Edited by - pberp on 12/19/2009 05:33:01
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
pberp
Starting Member
15 Posts |
Posted - 12/19/2009 : 19:46:26
|
quote:
Originally posted by tkizer
Yes, use backup/restore.
Thanks for your help.
One more question!
Are the system database(master,msdb,model) must be backuped and restore to the new machine? Or just only backup/restore the user database which one I wanted to copy?
|
Edited by - pberp on 12/19/2009 19:48:22 |
 |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
pberp
Starting Member
15 Posts |
Posted - 12/19/2009 : 20:53:52
|
I just want to move the database which one my application used.
If I don't copy the system database,what will happen? |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
pberp
Starting Member
15 Posts |
Posted - 12/20/2009 : 00:58:42
|
quote:
Originally posted by tkizer
It depends what you have stored in the system databases. In master are your logins. That can easily be recreated if you know the password. In msdb are the jobs, alerts and other things. I typically only need to grab my logins and jobs, so I don't ever bother restoring the system databases.
Thank you for your explanations!
|
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
| |
Topic |
|
Copy database from NT4.0 to Win 2000.
