Database restore

  • Hi Al,

    I want to restore a database from one server to another server.

    Can I restore a database with 8 datafiles as 2 data files on a different server? Is it possible?

  • No.

    A restore will create the same number of files and the same file sizes.

  • Then can I drop and recreate the DB with My choice of data files?

    But wait a min the how can I restore the data if its not possible..

    What options do I have if I want reduce the data files....

  • Mac1986 (11/4/2012)


    Then can I drop and recreate the DB with My choice of data files?

    Are you referring to the source database??

    Mac1986 (11/4/2012)


    But wait a min the how can I restore the data if its not possible..

    What options do I have if I want reduce the data files....

    Use this to empty and remove unwanted files on either the source or target databases

    dbcc shrinkfile(logical_name, EMPTYFILE)

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Mac1986 (11/4/2012)


    Then can I drop and recreate the DB with My choice of data files?

    But wait a min the how can I restore the data if its not possible..

    What options do I have if I want reduce the data files....

    What difference does it make how many files the database has?

    What are you trying to accomplish?

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

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