| Author |
Topic |
|
mike86
Starting Member
24 Posts |
 Posted - 2007-07-17 : 22:17:19
|
| Hi guys, any idea of how to recover the dump files of SQL Server 6.5 to SQL Server 7.0?M i K e |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-17 : 23:21:24
|
| You mean db backup file? I believe you should upgrade sql6.5 db to sql7 with upgrade tool. |
 |
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-17 : 23:32:56
|
| The SQL Server 7.0 has already been installed, and I've a dump file which was created by SQL Server 6.5. So how should I recover the dump file?M i K e |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-18 : 10:57:18
|
| You can't recover a 6.5 dump file in 7.0. You must use the upgrade wizard or some other method to get 6.5 databases into 7.0.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-18 : 21:23:20
|
| can u tell me wht methods or wht upgrade wizard i could use?M i K e |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-18 : 22:40:49
|
| If you install SQL Server 7.0, there will be a program in the SQL Server group.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-18 : 23:53:27
|
| may i know wht program is that? im still quite a dummy for sql server 7.0 thanks.M i K e |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-19 : 11:06:44
|
| It's upgrade wizard, installed with sql7. |
|
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-19 : 22:55:11
|
| i cant find any upgrade wizard, only the deployment wizard at the start program. can someone plz show me? tx.M i K e |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-20 : 11:15:55
|
| Then need run sql7 install again to get it. |
|
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-23 : 04:02:11
|
| ok now i got the upgrade wizard, but when i tried to proceed the steps at logon. it prompts an error msg: Windows only NT authentication has been detected on your SQL server 2000 server. upgrade requires sql server authentication. plz enable sql server and windows NT authentication on this server adn try again.anyone help?M i K e |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-23 : 13:26:41
|
| You need to enable mixed mode authentication in your SQL Server 7.0 system. Connect to 7.0 in Enterprise Manager, right click on your server, go to properties, then to security tab (IIRC, I haven't used 7.0 in a while). Switch to mixed mode (Windows + SQL authentication).Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-26 : 02:55:12
|
| ive recovered the dump file by 6.5 and installed 2000 on the same pc. how to enable the mix mode authentication in 2000?M i K e |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-26 : 06:34:20
|
| "how to enable the mix mode authentication in 2000?"Not sure that you need to, Windows/NT Authentication may be enough, but if you do I'm almost certain that its the same in SQL Version 2000 as it was in SQL Version 7 - i.e. as Tara described above.Kristen |
|
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-26 : 21:59:13
|
| ok, ive reinstalled the sql 2000 where the mixed mode authentication is required to be configured during the installation. now im facing problem in connecting sql server 2005.TITLE: Connect to Server------------------------------Cannot connect to localhost.------------------------------ADDITIONAL INFORMATION:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476------------------------------BUTTONS:OK------------------------------this is the error msg. could somebody help?M i K e |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-26 : 23:33:03
|
| Try connect to instance name instead of localhost. |
|
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-26 : 23:34:27
|
| do i need to create an instance for that? by using the server registration? ive tried that. but it doesnt work. when i try to browse for more at the server. there's hardly a thing for me to select too.M i K e |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-26 : 23:43:34
|
| Is it double post? |
|
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-26 : 23:44:54
|
| yeah sorrie, we can refer it at sql server 2005 forumM i K e |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-27 : 02:06:06
|
| Continued: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86970 |
|
|
|
mike86
Starting Member
24 Posts |
Posted - 2007-07-30 : 03:28:22
|
| hi all, thanks for helping me with the set up of sql server. i have posted a new problem at sql server 2005 forum, other topics, about the database diagram. plz take a look at it. tq.M i K e |
|
|
|
Next Page
|
Recover Dump Files of SQL Server 6.5