.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 2005 thinks a SQL 2000 backup is corrupt, but SQL 2000 restores just fine

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :
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

View Complete Post

More Related Resource Links

SQL 2000 backup to SQL 2005

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

sql server 2000 vs 2005


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

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?

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?



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.


How to restore SQL 2000 DB to SQL 2005

Hi, All
I am trying to restore SQL 2000 DB into SQL 2005 Database.
I backup the database from SQL 2000.

From Management Suit, I try to restore database but I can not see network drive from there even though SQL serveris running under network account.
I could see network drive from SQL 2000 or at least I can type path to find backup file. However I can not do this..

My Q is:
1. How can I restore this SQL 2000 db to SQL 2005 using network path?
2. Since backup is SQL 2000 database, when I restore into SQL 2005, does restore upgrade system tables and other schema to SQL 2005 as well?
If not, what is the best practice to upgrade this database into SQL 2005?
Upgrading SQL 2000 current server to SQL 2005 is not an option at this point.
Eventually porduction server will be scrup and install SQL 2005 and then restore DBs into production machine...

Thx in advance

Move 2000 Datawarehouse to 2005


Hi guys,


I have been asked to move one of our companies datawarehouses from SQL Server 2000 to 2005. I have made a backup of the 2000 datawarehouse and the .bak file is almost 14Gig. I have also saved the create scripts. What would be the best way to do this migration?

Do I create the tables on 2005 using the scripts i generated and then import the backed up data? if so what is the best way to compress this file since moving 13gig from 1 side of the world to the other on our network will be VERY, VERY slow. Or is there another better more efficient way?




Create table 2000 vs 2005... why the difference?


If I create a table by using a following simple statement:

create table manojtemp (

sn int identity(1,1) primary key not null,

fname varchar(20))

In SQL Server 2000 version I see a table & constraint object created.
But in SQL Server 2005 version I see a table & Index created.

And when I script both of them, I see:

--//  2000
-- Script TABLE
CREATE TABLE [manojtemp] (
[sn] [int] IDENTITY (1, 1) NOT NULL ,
[fname] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

-- Script Constraint

port sql 2000 to sql 2005


Need url on good kb or article on converting sql 2000 to sql 2005 (full version not express)


Michael Oard

SSRS 2000 reports when upgraded to 2005 report with subreport really really slow


We recently upgraded a report server and corresponding reports from SQL Server 2000 (reports 2003) to SQL Server 2005. After upgrade one of our reports which use two subreport is very very slow.

The sp's used for these all these reports are fast. All the sp's together takes about 40 secs.

Both in the BIDS environment as well as the report site the report is very slow.

We are using a database in which data is inserted through replicatoin. In all our sp's we have given 'with nolock' along with the table names.

Can anyone please help me here?

SQL Server 2000 Backup Fails


Hello Everyone and thanks for your help in advance.  I am trying to backup a SQL Server 2000 database to an external hard drive.  I am attempting to do a complete backup, however, each time I attempt this I receive the follwoing error:

Write on "M:\SQL Server\MYDATABASE.bak' failed, status = 1117.  See the SQL Server error log for more details.

BACKUP DATABASE is terminating abnormally


In the event viewer, I receive Event ID 17055 with the message:


BACKUP failed to complete the command BACKUP DATABASE [KidsLocal] TO  DISK = N'M:\SQL Server\MYDATABASE.bak' WITH  INIT ,  NOUNLOAD ,  NAME = N'MYDATABASE backup',  NOSKIP ,  STATS = 10,  NOFORMAT

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