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 |
|
chander_2580
Yak Posting Veteran
76 Posts |
 Posted - 2007-05-23 : 18:06:05
|
| Hi guru!! please help me :( .. i m in very critical situation because of the following scenario.. we have been using sqlserver 2005 (evaluation version)and yesterday eval version expires ... now i have installed sqlserver 2005 (enterprise edition) on my server,i have all the mdf and ldf files for databases and also have full backup set of all dbs on server except system database. So now i want to reset server. So please help me in reinstalling all databases back to server with logins. i want to know abt the steps that lead me to successful re-installation of dbs.for your info .. i have all mdf & ldf files for dbs alonghwith backup set of dbs otherthen sys dbs ... please help me ..thankschander |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-23 : 22:36:38
|
| You can restore dbs from backup files with 'restore database' statement, or attach db files in new instance with sp_attach_db. For sql logins, you can copy them with ssis task. |
 |
|
|
|
|
|
re-installing databases on new server