.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL 2000 backup to SQL 2005

Posted By:      Posted Date: September 05, 2010    Points: 0   Category :Sql Server
Hi I have this problem  My management application ( using Delphi ) was using a database in SQL 2000 I planning to upgrade the SQL Server 2000 to 2005 same Standard Version  The migration using simple method : 1. Backup the db in SQL 2000 2. Create a db with same name in SQL 2005 with compatibility back to SQL 2000 3. Restore the backup to SQL 2005 and ready to use I can select update insert do all the transaction in SQL 2005 normally but the problem is the managment system always report can't connect to SQL Server and also one problem I cannot change the management system code since it create by somebody outside the company and already long gone or not care about this software anymore. So my only hope is to see if there something wrong with the SQL Server I check the typical sql syntax for delphi to connect to SQL Server there is no different between connecting to 2000 or 2005 the connection string also similar to other programming language. ( I also try using my own built application in C# it works well i just need to change the dsn on the IP part ) From the error report by the old program ( the one using Delphi ) it indicates that it was user pass problem, so I recreate the user in the sql 2005 version to be the same as SQL 2000 than check using the .udl it both connect well, but from the software still report it can't connect. It also appear that if I

View Complete Post

More Related Resource Links

SQL 2005 thinks a SQL 2000 backup is corrupt, but SQL 2000 restores just fine

I am attempting to move some SQL 2000 databases to SQL 2005. My main production database does not seem to want to move. When I use the SQL 2005 GUI the .bak backup file is marked 'Incomplete'. When I attempt to restore the backup file I get a 'RESTORE detected an error on page (0:0) in database' message. I saw a thread in the SQL Express forum suggesting trying to restore from the T-SQL level to get the GUI out of the picture and I get the same 'error on page (0:0)' message.  However when I take the same file and use SQL 2000 Enterprise Manager it restores with no problems.

Any ideas?

Mike Mattix

sql server 2000 vs 2005


i would like to ask what the difference between sql server 2000 and 2005 

Sql Server 2005 backup misses files

I have a SQL Server 2005 database that contains 3 files.  Sometimes when I run rhe backup, it appears to only backup 2 of the three files.  The only way I can get it to return to a full backup is to restore the database from a backup tape.

Can't restore database backup file in my database ? using sql server 2005. please help

VERY IMPORTANT i am trying to restore database.bak in sql server 2005 (i know the database.bak was also generated in sql 2005 server) i am trying to restore back up database .bak into the new database i just created in sql server 2005 i have saved my database .bak into c drive and when i select database .bak "From Device", it doesn't get populated in the list below and i see nothing and it keeps on prompting a message "You must select a restore source" Here's the screen shot:   PLEASE HELP..it's really important (i tried restoring database in sql server 2008 and it was sucessful but i am facing this problem in sql server 2005 only)  

Is there a way to backup all my store procedures under a particular SQL 2005 database?

hi all, Is there a script, doc, VBS script, SQL statement out there which will read all my store procedures and save them as a TXT file? Currently I have to save all of them in text files before I update them when I get a new web site release. Thank you  JCD

how to restore msdb database on sql 2008 from sql 2005 backup?

Currently, I am unable to do it. It gives me the error than I cannot be restored because it was created by a different version of the server. What is the work-around? I hate scripting all my maintenance plans and alerts, there are tonns of themJulieShop

SQL Server 2000, or SQL Server 2005 failover clusters on the 32-bit subsystem (WOW64)

Hi All I don't know what is WOW64,some where I read "SQL Server 2000, or SQL Server 2005 failover clusters on the 32-bit subsystem (WOW64)" In my environment SQL Server 2000 version is "Microsoft SQL Server  2000 - 8.00.2282 (Intel X86)   Dec 30 2008 02:22:41   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) " is it same ?? How find out my environment is WOW or NOT. Thanks in advance          SNIVAS

migration MSDE 2000 SP3 database to SQL 2005 SP3: low performance on 2005 Express

I've detach MSDE 2000 SP3 database. I've attach into SQL 2005 Express SP3 and SQL 2005 Standard SP3. I've change compatibility level to 90. I've update statistics with EXEC sp_MSforeachtable @command1="UPDATE STATISTICS ? WITH FULLSCAN" The execution time of a TSQL into the same hardware (1 CPU, Quad Core) are: SQL 2005 Express SP3: 20" SQL 2005 Standard SP3: 0" The execution plan is different. Why?

Why doesn't SQL Server 2005 Enterprise always shrink a log file after a backup?

I have several databases that, despite being backed up regularly, do not release space to the operating system.  In one extreme case, I have a log file that is less than 1% utilized (and has been for months.) I know how to manually force a shrink, but I should not need to do that on any sort of regular basis.  In fact, it is against best practices to manually shrink a log file (or any database file for that matter) because of the very high risk of an unrecoverable error. It is my understanding that SQL Server will eventually handle these things on its own.  However, it does not appear to be doing so.  Any thoughts as to why? Thanks, Dave

Restoring Databases form SQL Server 2000 and SQL Server 2005 to SQL Server 2008 -Side by Side --he

Hi all I Installed SQL Server 2008 R2 in Server and I took backup of all the User databases backup from 2000 and 2005(two instance are running) Now I am doing restore the Databases,while I am restoring I am information icon in bottom of the restore window that is "The Full-Text Upgrade Option server property controls whether full-text indexes are improved,rebuild or reset" that means I have to upgrade full-text indexes or this just inforamtion.If I want find out whither Database using full-text how to check ? once I done this I have to move the users as well.Please dome body share the script you have.   Thanks in AdvanceSNIVAS

Poor performance on Sql 2005 vs. Sql 2000 - AGAIN!


I was hoping I wouldn't be another poster with performance issues after migrating to SQl 2005 from SQL 2000 but here I am.


I am in the process of testing out our databases on Sql Server 2005 for migration from SQL Server 2000 and there are certain portions of code that have been affected negatively. I have read thru many of the posts here and have tried out most of the recommendations. I will start out with things I've done and then provide the actual SQL.


1) I have rebuilt all indexes ( using the DBCC REINDEX using the table option).

2) Updated the db engine to latest hot fix (build 3239) that addresses speed related fixes.

3) I also ran sp_createstats using the 'fullscan' option to create stats on all columns of all tables (minus indexed columns)

4) Since nothing seemed to work, I even ran UPDATE STATICS with FULL SCAN on all tables even though I did not need it as the REBUILD woudl have created stats. But I was willing to try anything.


I have confirmed that the execution plans are different even though the data on both sql 2000 and sql 2005 are identical (i put a copy on 2005). The plans themselves are huge as the queries are huge. Here is the query.

copy partition data from 2000 cube to 2005 cube



i am upgrading 2000 olap cube to 2005.  i built an ssas project and deploy to the server.

the 2000 olap cube store it's data in partitions - one for each month.

the face table delete it's data and store data for only the last 13 month so basically most of the data

is store onle in the 2000 cube.

while upgrading the cube and processed it , a lot of information had lost.

i know that i cant restore the fact from the partiotn data but is there a way to copy the partition has is

from olap 2000 to 2005?


Can I run Sql server 2000 client tools and SQL server 2005 on teh same machine.



Could you please advise me on this issue.

I have installed sql server 2000 client tools, and complete set up of sql server 2005 on my system.

The enterprise manager on sql 2000, crashes and and window vanishes, when ever i try to create DTS package.

They doubt its becos i am runnning both instance of sql server on the same machine- So its having some compactability issues.?

Can we run SQL server 2000, 2005 and 2008 on same machine with different instance ?

I am using windows 7 and i3 processor.

Thanks in advance.



DTS on sql server 2000 and 2005


Here at work most of us have SQL Server 2000 and 2005 installed on our machines. When one of us creates a 2000 DTS package on our machine, it cannot be opened on on any other machine with the same setup. It will only open on the machine where it was created. We have had to use a machine that has only a 2000 installation in order to create DTS packages that can be opened on other machines.

Is there a solution to this problem?



SQL 2005 backup and restore onto new server - for DR and testing purposes

all I have a beefy server that currenty runs my SQL server, however i would like to backup this server and restore it to a different server then use SQL replication in a DR solution.


I have W3K R2 SP1 with SQL 2005 (version 9.00.3042.00)
The phycial server has:
DISK 0 - C: (conatins OS and system files 12GB)
and E: (conatins SQL logs 124GB)

DISK 1 - D: (some program files, and the SQL DB 408GB) - Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

all DISK's are NTFS formatted

How can I best accomplish my goal?

Should I use NTBACKUP and then do a restore onto a new server?
Should I build a new sever with W3KR2 with the same partitions and then backup the sql db via sql and do a restore onto the new server?
could I utilise hyper-v?

I do not have much experience with MS SQL server.


cannot restore sql 2000 database in sql server 2005 in windows 7


cannot restore the databse made in sql server 2000 in sql server 2005 in windows 7 with thw following error message

TITLE: Microsoft SQL Server Management Studio Express

Restore failed for Server 'KHURANA\SQLEXPRESS'.  (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476


System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476



plz help me out

Error Restoring sql 2000 backup on SQL 2008 Error: 928


I'm restoring several sql 2000 user databases on a sql 2008 r2 box, but sometimes I receive the following error

Error: 928, Severity: 20, State: 1

During upgrade, database raised exception 156, severity 25, state 1, address 0000000001C05A9F. Use the exception number to determine the cause.

So the error occured after the restore and while upgrading the database schema from version: 539 to 661.

However I notice that if I try to restore it again with the same statement, sometimes it goes sometimes it doesn't.

I'm not finding any 823,824 or 825 errors on SQL log.

The database compatibility level is 80.

While running Upgrade Adivsor on the database I saw 27 objects that use the older outer join sintax *=. However being that just a warning I don't think that's the cause, moreover because if I retry sometimes the restore completes succesfully.

Does anybody knows what is this?

Is this the I/O subsystem failing?

Why is this intermitent?

How do I fix it?


Thanks in advance.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend