sql server 2000 database file unable to attach in sql server 2008 ?

hi,
i try to attach Sql server 2000 database file in sql server 2008 i got the following error,
i tried in google, but my problem is not solved ...

Attach Database Failed for Server 'Aru2008' (Microsoft.sqlserver.smo)
An severe error occured on current command. the results if any should be discarded.. Converting database 'Costing0809'
from version 539 to 655. Database 'Costing0809' running the upgrade step from version 539 to version 551...

Plz help me ....

Thanx in Adv.

Bye
Ganesh

** Edit **

Attached Images

Sql Attachment Error.jpg (39.9 KB, 1269 views)

Oct 6 '11 #1

Subscribe Post Reply

✓ answered by ck9663

Why not backup your db in sql2000 and restore it in sql2008 instead?

~~ CK

3722

ck9663

2,878

Expert 2GB

Why not backup your db in sql2000 and restore it in sql2008 instead?

~~ CK

Oct 6 '11 #2

ganeshvkl

HI ,

Thanks For Your Reply, there is one table is corrupt in the Database file , i create New database and Import all the data, skip the corrupt table , now it's working Fine...

Once Again Thanks....

Bye

Ganesh

Oct 7 '11 #3

by: Marcin | last post by:

Hello I need this course (Course 2073: Programming a Microsoft SQL Server 2000 Database ) from Microsoft materials. If someone knows from where can I download this materials or could sent mi...

Microsoft SQL Server

Convert a existing SQL Server 2000 database to 2005

by: Philipp | last post by:

Hey @ all, I have a question: It is possible to convert an existing SQL Server 2000 Database to SQL Server 2005? best wishes!

Microsoft SQL Server

VS 2003 + opening a connection to SQL SERVER 2000 database

by: Jon Delano | last post by:

Hey all I am building a new computer. I have Windows XP Pro with SP2 and all the updates. I installed VS 2003. Then copied a project from my old computer to the new one. When I try and run...

ASP.NET

Porting SQL Server 2000 database to PostgreSQL

by: Rod Early | last post by:

I have the task of converting a SQL Server 2000 database to PostgreSQL. The data itself does not need to be converted, but the structure and stored procedures must be. I expect that converting...

PostgreSQL Database

dataform wizard in visual studio 2003 and sql server 2000 database

by: Ralph | last post by:

I am trying out the dataform wizard in visual studio using a sql server 2003 database. It seems to want to create ole db adapters and connections and commands. How do I make it use sql commands...

C# / C Sharp

The SQL Server management pack script "SQL Server 2000 Database Health" is unable to

by: Jimmy Liew | last post by:

hi, I found this error message in my Ms SQL Server error log. Does anyone know what is all about? What I should diagnosis on this? The SQL Server management pack script "SQL Server 2000...

Microsoft SQL Server

SQL server 2000 - database problem

by: Jaros³aw Kozik | last post by:

my database status is suspect - what can I do to rebuilt it ( using enterprise manager or something else ) ? regards IJKK

Microsoft SQL Server

Development environment setup: connect to SQL Server 2000 database

by: =?Utf-8?B?ZGF2aWQ=?= | last post by:

Last week I asked a question about connection to database from client machine (developer machine). I have changed the database security setup for "SQL Server and Windows" under (local)Windows NT...

ASP.NET

ASP.NET C# web application to connect to SQL SERVER 2000 database

by: jojo41300000 | last post by:

Hi, I have a problem with database connection to SQL server 2000 from ASP.NET. When I try to connect, it give me the errors. But, When I try to connect to SQL SERVER 2005. It works fine. ...

Microsoft SQL Server

problem with MS sql server 2000 database table

by: arial | last post by:

Hi you all experts, Here, I am running into strenge situation. I have ms sql server 2000 database and one of the table is acting strenge. I have trigger placed on this table to move data to the...

Microsoft SQL Server

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

sql server 2000 database file unable to attach in sql server 2008 ?

✓ answered by ck9663

Similar topics