| Author |
Topic |
|
token
Posting Yak Master
133 Posts |
 Posted - 2006-01-23 : 06:16:46
|
| Yes this is a silly question, but I don't know the answer!I have developed a database using SQL Server 2K. I am now upgrading to SQL Server 2005. Can I still use my current database files in SQL Server 2005? If I can, do u have any idea how I can make SQL Server 2005 load up the old files and start working?Also my hosting provider has NOT upgraded to SQL Server 2005. He will only accept the old SQL Server 2K files. Can SQL Server 2005 save files that will work on a SQL Server 2K server?Thank you!!! |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-01-23 : 07:11:10
|
I dont think any question is silly.Guess we all are learning and learnt one day  Yes, you can. But guess someone else would give you the details soon. |
 |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-01-24 : 09:58:22
|
| 1: Yes, you will be able to Upgrade your Database from the 2K platform to 2005.Visit this link for more info[url]http://msdn2.microsoft.com/en-us/library/ms143713.aspx[/url]2:This topic describes how to use the Copy Database Wizard to upgrade a SQL Server 2000 database to a SQL Server 2005 database.When using the Copy Database Wizard to upgrade a database, adhere to the following requirements:Before upgrading, place the database in single user mode, and make sure that no applications or services are trying to access the database. Do not use read-only mode, as this will result in an error. You cannot rename the database during this operation.ProcedureTo upgrade a SQL Server 2000 database to a SQL Server 2005 databaseConnect to any instance of SQL Server Database Engine using Object Explorer in SQL Server Management Studio.Expand Databases, right-click a database, point to Tasks, and then click Copy Database.Complete the steps in the wizard. Visit this link for more info[url]http://msdn2.microsoft.com/en-us/library/ms190775.aspx[/url]3: If your Host is not going to allow you to migrate, is it worth your time to migrate??If you want your computer to be faster then throw it out of the window. |
|
|
|
Anup Shah
Starting Member
14 Posts |
Posted - 2006-01-24 : 16:41:25
|
| yes ofcourse,first i think u aware of feature of sql2000 attach and detach database.now if u don't have any problem with uninstalling the sql2000 then detach your databse, copy all .MDF and .LDF file to safe location and uninstaal 2000 then install 2005 with same server name as 2000 had. next thing u need to do is just copy the .MDF and .LDF files to original(default) location and attach database.but if u don't want to uninstall the sql2000 then as our friends repalied refer that link and u will get step by step upgradation info. make sure about when u provide login options(use window login / use sqlserver login) and server name. this things must be same as older one. u are not supposed to change any thing in it.that makes your older file not work or databse not found later.well, thats easy options i know.if i make mistake let me know. |
|
|
|
token
Posting Yak Master
133 Posts |
Posted - 2006-01-27 : 15:07:42
|
| Thanks for the replies, they've really helped me out.I unintalled SQL Server 2K and installed 2005 version. But I made a copy of the database files and kept them in a seperate folder before I uninstalled the 2K version.I created a new database in SQL Server 2005 with exactly the same name as my old database, but the new version has a default place where it stores the database files (C:\Program Files\SQL Server\MSSQL.1\MSSQL\DATA).What I want to do is to be able to change this path to point to the folder where the old database files were kept. Then I am able to have my database back. Essentially I want to do what Anup Shah said, but the default location for SQL Server 2005 is in the SQL Server program files folder. I don't keep my files there... I keep my files in a different folder.I am able to restore the database from the backup file, but unfortuantely my back-up is a little bit old.Thanks for your help guys. |
|
|
|
Anup Shah
Starting Member
14 Posts |
Posted - 2006-01-27 : 23:13:40
|
| I sm little confuse from your last post that now u r done with your question or u have still some problem with it.?If u have problem with relocationg the old/new data base file then u can do that by the same Attach/dettach operation from enterprise manajer and allocate new path. |
|
|
|
token
Posting Yak Master
133 Posts |
Posted - 2006-01-28 : 13:48:26
|
| I am now using SQL Server 2005 so I have the Management Studio (almost same as Enterprise Manager) but I can't find anywhere where I can allocate a new path/folder where I want my database files to be saved.Help meeee! :-( |
|
|
|
token
Posting Yak Master
133 Posts |
Posted - 2006-01-28 : 23:07:34
|
| Right, i think i've sorted it.....What you need to do is:1) Open up SQL Server Management Studio2) Make a new database with the same name as your old database3) Right click on the new database > Tasks > Restore > Files and FilegroupsIn Files and Filegroups you go to Options and type in the path of where the old database files were. |
|
|
|
|
silly question here