1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Problem importing SQL Server 2000 *.bak files into SQL server 2005

Discussion in 'Windows XP' started by BlackHorseman, Sep 11, 2006.

Thread Status:
Not open for further replies.
Advertisement
  1. BlackHorseman

    BlackHorseman Thread Starter

    Joined:
    Apr 27, 2002
    Messages:
    451
    Hi,

    The procedure is as follows:
    ---------------------------------
    Right-click databases -> Restore Database
    I mark 'from device', click the '...' button & select 'File' in the dropdown, then brows to the file itself. Under 'select the backup sets to restore' I check the only checkbox there, then in the 'To Database' I select the name of the database in the file (a new DB name appears there as you select the file).

    Then I press OK and receive the error message in the attached file.
    I need to be able to complete the import.

    Thanks,
    Daniel.
     

    Attached Files:

  2. BlackHorseman

    BlackHorseman Thread Starter

    Joined:
    Apr 27, 2002
    Messages:
    451
    Is this at all possible?
    Is this the right forum?
     
  3. ozrom1e

    ozrom1e

    Joined:
    May 15, 2006
    Messages:
    11,849
    Well for this problem we are going to need some more information

    n order to better respond to your question or problem

    We require more detailed and specific information
    And Please fill in the questionnaire or Fill in the
    Computer Specifications in your TSG profile



    Please repost your request with:

    Computer: Brand Name
    Computer: Model Number

    Age of system:

    CPU: Brand, speed

    Ram: Type, amount, speed

    Peripheral devices

    Operating system: Windows 98, 98SE, ME, XP Home, XP Pro, Other, and Service Pack Installed.
    Are you dual booting on this computer?
    If so what operating system is the other boot?
    Name, version #, date of most recent AV signature file

    Vdeo Card: Brand Name, type, speed, Chipset, driver version and date

    Video settings: resolution, advanced settings

    Please state your specific problem and when it started

    Did you change anything, install anything before the problem started?

    List any recently installed software

    List software running in background ie: anti-virus program, mail programs, backup software.

    Any power disruption or incomplete shutdowns

    Failed Scandisk/chkdsk or defrag attempts

    Use of any “tune-up” utilities, registry utilities, system diagnostics, other third party utility software

    Recent downloaded software

    Any new programs or files that have recently appeared in your STARTUP menu or msconfig STARTUP listing


    This information may be of critical importance in locating and correcting the source of your problem. Please note any additional information or detail about the problem that may be of value in our assessment of the problem.

    Thank you.
     
  4. BlackHorseman

    BlackHorseman Thread Starter

    Joined:
    Apr 27, 2002
    Messages:
    451
    Hi,

    Sorry for taking so long to respond.
    In fact, the problem can be solved very easily: the DB should be restored on an SQL Server 2000, then you create a database with the name you need on an SQL Server 2005 and perform an 'Import Data' from the SQL Server 2000.....

    Guess I'm the last person in the world to make this great discovery, but, well....
    Thanks for trying to help : )

    D.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/500182

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice