Post reply

sql server 2000

  • March 27, 2009 at 10:17 pm

    #207645

    may i take backup and restore database from client machine to server in sql server 2000 and sql server 2005

  • March 27, 2009 at 10:37 pm

    #967827

    yes...you can take a SQL 7 or 2000 backup and restore it on a SQL2005 server; the restore automatically upgrades it to the newer format; you just cannot do the reverse....

    you cannot take a 2005 backup and restore it on SQL 2000; it won't work.

    as an FYI, because it can be misleading, the database compatibility level, ie 80 or 90, just determines which syntax is valid for any TSQL commands hitting the database, it does not have anything to do with the way it is stored or backed up.

    HTH

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply