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 3, 2012 7:31 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 14, 2014 1:28 AM
Points: 219, Visits: 693
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 4, 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: Today @ 4:28 AM
Points: 3,113, Visits: 11,537
No.

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

Post #1380761
Posted Sunday, November 4, 2012 2:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 14, 2014 1:28 AM
Points: 219, Visits: 693
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 4, 2012 2:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 6,752, Visits: 14,400
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 5, 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: Today @ 4:28 AM
Points: 3,113, Visits: 11,537
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