Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2003
    Posts
    44

    Unanswered: Transfering a DB

    here's my prediciment, I need to transfer my SQL DB to another SQL Server, but I don't have access to the server, I get the login through a third party company.

    So what do I need to do to transfer the database to another server as an EXACT copy of my original database, IDENTITY Fields and all.

    Thanks

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    backup/restore by 3rd party?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Dec 2003
    Posts
    44

    Not sure

    Not sure what you mean?

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Backup your db, send the file to the 3rd party and ask them to restore the db from the backup.

    Option 2 - ask them to give you sysadmin server role and restore the db yourself.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    snaked...

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Quote Originally Posted by Ruprect
    snaked...
    So, what happened to you? I went to Mamacitas (or whatever it's called) and ended up at Flying Saucer...You missed your chance, dude!
    Last edited by rdjabarov; 10-07-04 at 03:32.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  7. #7
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    hey i called you and left a message on your cell.

    i hope you werent too put out but if you didnt get the mess.
    i had to fly out of town at the last min and wont be back until next week
    i was on a plane 3 hrs after finding out i was going.

    sucks.

    sdavis

  8. #8
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I got it, just waiting for the call...the wife is deprived of any communication with the rest of the world (joke, I think) until I get the latest scoop on WHAT THE HELL HAPPENED!!!!
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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