Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database restore Expand / Collapse
Author
Message
Posted Saturday, November 03, 2012 7:31 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, February 01, 2014 5:00 PM
Points: 193, Visits: 621
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?
Post #1380756
Posted Sunday, November 04, 2012 12:49 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:11 PM
Points: 3,081, Visits: 11,230
No.

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

Post #1380761
Posted Sunday, November 04, 2012 2:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, February 01, 2014 5:00 PM
Points: 193, Visits: 621
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....
Post #1380770
Posted Sunday, November 04, 2012 2:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:51 AM
Points: 5,958, Visits: 12,839
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"
Post #1380777
Posted Monday, November 05, 2012 7:37 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:11 PM
Points: 3,081, Visits: 11,230
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?



Post #1381082
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse