November 3, 2012 at 7:31 pm
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?
November 4, 2012 at 12:49 am
No.
A restore will create the same number of files and the same file sizes.
November 4, 2012 at 2:14 am
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....
November 4, 2012 at 2:56 am
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" 😉
November 5, 2012 at 7:37 am
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