Results 1 to 4 of 4

Thread: importing a new database

  1. 04-24-2007, 07:10 AM #1
    gidmakus
    gidmakus is offline Registered User
    Join Date
    Apr 2007
    Posts
    1

    importing a new database

    I use ms sql 2000 and i wanted to import a new backup database into a new ms sql 2000 on a different machine but it does not work so i wanted to know if it can be done or i have to do something else thank u.
    Reply With Quote Reply With Quote
  2. 04-24-2007, 10:49 AM #2
    nosepicker
    nosepicker is offline Registered User
    Join Date
    Dec 2004
    Posts
    502
    Yes, this can be done, either through Enterprise Manager or T-SQL. What did you do and what error messages did you get?
    Reply With Quote Reply With Quote
  3. 04-24-2007, 07:13 PM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    If you have db backup file, you can restore it.
    Reply With Quote Reply With Quote
  4. 04-26-2007, 06:04 AM #4
    Murali Karumuru
    Murali Karumuru is offline Registered User
    Join Date
    Apr 2007
    Posts
    1

    Smile Restore DB backup to a different server

    http://www.microsoft.com/technet/pro...est.mspx#E4JAE
    Hope that helps,

    Best,
    Murali
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules