Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: DB copy using backups; tempdb on diff. drive

    I'm having difficulties copying a production DB to a new computer using backup files. The production computer had tempdb on the D: drive, the new computer is much smaller and only has a C: drive. I've successfully restored the Master DB backup but now the database will only start with the (-F) parameter. I know how to Alter the DB to move the tempdb, but I cann't get the DB to start while Tempdb is pointed to the D: drive

  2. #2
    Join Date
    Jan 2004
    Location
    Boston
    Posts
    58
    That's because you are using the original master db which keeps the tempdb data and log file path in it's sysdatabases table. You need to modify the table and change C:\ to D:\ in the path before you back up master and restore it on the destination server.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54

    Re: DB copy using backups; tempdb on diff. drive

    Originally posted by rfalor
    I'm having difficulties copying a production DB to a new computer using backup files. The production computer had tempdb on the D: drive, the new computer is much smaller and only has a C: drive. I've successfully restored the Master DB backup but now the database will only start with the (-F) parameter. I know how to Alter the DB to move the tempdb, but I cann't get the DB to start while Tempdb is pointed to the D: drive
    While using the -F option to start the server, you should be able to use Example I to move tempdb.

    -PatP

  4. #4
    Join Date
    Jan 2004
    Location
    Boston
    Posts
    58
    His problem is the SQL server can't even start due to incorrect tempdb path. Your solution works only when sql server is started.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    At least as I read his first post, he can start SQL Server using the -F parameter. Did I miss something?

    -PatP

  6. #6
    Join Date
    Oct 2003
    Posts
    2
    Thanks for the replies; Starting the DB with the -f parameter allowed me to change the location of tempdb, then restart the database normally.

Posting Permissions

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