• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • Last Modified:

microsoft, microsoft sql server, sql server 2005, fresh install from sql 2000 backups

I am currently running sql server 2000 on an old server. I have purchased a new server and would like to install sql server 2005 from a fresh install. Will I be able to back up sql server 2000 and restore it on the new server sql server 2005? I am a rookie when it comes to sql and would appreciate some assistance in procedure etc...

Thanks in advance.
0
zingab
Asked:
zingab
  • 8
  • 7
1 Solution
 
WizillingCommented:
yes u can backup ur sql 2000 dbs and restore as u normally would on sql 2005.
also detach - copy - attach would also work
0
 
WizillingCommented:
Also note that logins for users will not be restored this will have to be done separately

http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
0
 
zingabAuthor Commented:
Ok im a beginner in the sql stuff...Is there a way to back up all my Microsoft Sql Server 2000 databases and all configurations and install on the sql server 2005. Please provide more granual instructions.

Thanks !!!!
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
zingabAuthor Commented:
the tool wont help im instaling sql 2005 on a different server all together. Guess there isnt any way to move all my settings user accounts and configurations,
0
 
WizillingCommented:
well the tool actually tels you what objects can be upgraded and what objects /t-sql statements that u should change so that they are funcitonal in sql 2005..

u can try making a duplicate copy of your exsisting sql 200 environment.. (or maybe u already have a test server taht u can already use)
perform the sql 2005 upgrade on the test machine.. it will migrage all ur settnigs and acounts to the new server.
please note (TEST is out first before doing on procuditon)..and also when u do do it on production , remember to make sql server backups and test the restores and also I would keep a seperate server as a standby .
0
 
zingabAuthor Commented:
i will test some stuff out and let you know. I appreciate you responding (you are the only one!!!!)

Thanks again.
0
 
zingabAuthor Commented:
Can you lay out the steps for me of how to copy a sql 2000 database to a sql 2005 database.
The steps are somewhat vague from all the links.

THanks
0
 
WizillingCommented:
Hi , This is a very Good article.. step by step process on how to migrate databases. Just do this from your sql 2005 server. Ur source will be the sql2000 server and the destination will be sql 2005.

0
 
WizillingCommented:
0
 
zingabAuthor Commented:
ok thanks!! I will try that once I have a chance.

Is there the same sort of step by step for moving username and passwords over also? The only thing i found was a script but am not sure where and how to run it.

Thanks again for responding to all my question!!
0
 
WizillingCommented:
Hi , no problem...
This should do it for the users / passwords.

http://support.microsoft.com/kb/246133/

0
 
zingabAuthor Commented:
Thanks for all you help, I am still in the process of testing, as you know things always come up they divert your attention. I should have it tested early next week and will def. give you  the points once its all finished. Id give you more but 500 is max!

Thanks again
0
 
zingabAuthor Commented:
still havent gotten to this issue,. will update once i have .

thanks
0
 
zingabAuthor Commented:
as of now i will test next week please keep this issue open tilll then

thanks
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now