| Author |
Topic |
|
satishvsh
Starting Member
41 Posts |
 Posted - 2008-06-10 : 15:01:33
|
| Friends -Is it possible to restore user databases in SQL Server 2005 with user database backup copy of SQL Server 2000.Please advise on this.Cheers:)VSH |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-06-10 : 15:03:16
|
| Yes. It is possible. Did you try?MadhivananFailing to plan is Planning to fail |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
satishvsh
Starting Member
41 Posts |
Posted - 2008-06-10 : 15:06:55
|
quote:
Originally posted by madhivanan
Yes. It is possible. Did you try?MadhivananFailing to plan is Planning to fail
Thank you Madhivanan. I am going to implement this now, b4w that i would like to know some few suggestions.Cheers :)VSH |
|
|
|
satishvsh
Starting Member
41 Posts |
Posted - 2008-06-10 : 15:07:48
|
quote:
Originally posted by tkizer
Not only is it possible, but it's also one of the ways you upgrade databases.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Excellent, you cleared my doubt.Thank youVSH |
|
|
|
satishvsh
Starting Member
41 Posts |
Posted - 2008-06-10 : 15:13:10
|
quote:
Originally posted by tkizer
Not only is it possible, but it's also one of the ways you upgrade databases.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Tara -If we upgrade database like backup and restore then how abt the system databases (master, msdb, model). Please advise on this.Cheers:)VSH |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
satishvsh
Starting Member
41 Posts |
Posted - 2008-06-10 : 15:25:58
|
quote:
Originally posted by tkizer
I move everything that we need from those using scripts. For logins, I just use this: http://www.sqlmag.com/article/articleid/16090/16090.htmlFor jobs, I script them out on the source and then run that script in the destination.We don't save anything in model, so I don't need to transfer anything for that.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Thank you for your quick response tara. What is your email to contact you. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-10 : 15:35:18
|
| I do not provide that information on the Internet. You can use the email option in my profile or on my blog. When I reply to it, you will see my email. Be warned though that my support will not be cheap.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-10 : 19:19:26
|
| " What is your email to contact you."Why you have to contact Personally? Are you embarrashed to ask question? |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-06-11 : 10:39:32
|
| Microsoft provided script for transfering logins from 2000 to 2000 and from 2000 to 2005.With the help of 2 sp you should be able to do that,1) sp_help_revlogin and 2) sp_hexadecimalYou can find those sp's from MS site as well.http://support.microsoft.com/kb/246133For jobs and DTS package you may need to script it out.ManojMCP, MCTS |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-06-11 : 15:33:57
|
| I would not move SYSTEM, MASTER FILES FROM SQL 2000 TO SQL 2005 they are completely different now...Just install SQL 2005 on the server.Do backup SQL 2000 then in SQL 2005 Restore.Do the logins as listed below on SQL 2000 it generates a text file..then in SQL QUERY IN SQL 2005 just do execute. |
|
|
|
|
SQL 2000 DB backup restore to SQL 2005 DB