Post reply

backup and restore question

  • January 16, 2008 at 9:55 am

    #71341

    SQL Server 2000. refreshing Production Database to Backup Database on the same Instance.

    Backup and restore or DTS?????

  • January 16, 2008 at 11:38 am

    #768858

    anyone? I'm hesitating to use backup and restore becasue both databases are on the same instance. They have different DB Names and their data and log files are named different but their 'logical' filenames are the same.. does that make a difference??

  • January 16, 2008 at 11:41 am

    #768859

    If your aim is to have an exact copy of the original database, I'd go with backup and restore with move. I've had trouble transferring users and permissions with DTS.

    Greg

  • January 16, 2008 at 11:56 am

    #768870

    Thanks Greg! so it doesn't matter if the logical names are the same as long as the database names and the physical filenames are different???

  • January 16, 2008 at 4:56 pm

    #769011

    That's right.

    Greg

Viewing 5 posts - 1 through 4 (of 4 total)

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