Results 1 to 3 of 3

Thread: SQLServer 2005 restore to 2000

  1. #1
    Junior Member
    Join Date
    May 2006
    Answers
    1

    SQLServer 2005 restore to 2000

    Hi! anyone who knows how to backup DB from SQLServer 2005 and restore to SQLServer2000?


  2. #2
    Expert Member
    Join Date
    Sep 2005
    Answers
    206

    Re: SQLServer 2005 restore to 2000

    Quote Originally Posted by sonzls
    Hi! anyone who knows how to backup DB from SQLServer 2005 and restore to SQLServer2000?


    Hello,

    I don't think it will work since SQL Server 2000 knows nothing of the new features of SQL Server 2005. There are few tools using which can script your database and create insert statements which you can use to get the data back to sql server 2000.

    Thanks,


  3. #3
    Junior Member
    Join Date
    Apr 2007
    Answers
    2

    Re: SQLServer 2005 restore to 2000

    yes it will be work


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact