Database restore

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Database restore

Database restore

Rate Topic

Display Mode

Topic Options

Author

Message

Mac1986

Posted Saturday, November 03, 2012 7:31 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:33 AM
Points: 180, Visits: 512

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

Michael Valentine Jones

Posted Sunday, November 04, 2012 12:49 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 10:01 PM
Points: 2,944, Visits: 10,504

No.

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

Post #1380761

Mac1986

Posted Sunday, November 04, 2012 2:14 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:33 AM
Points: 180, Visits: 512

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

Perry Whittle

Posted Sunday, November 04, 2012 2:56 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 5,201, Visits: 11,153

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" Wink

Post #1380777

Michael Valentine Jones

Posted Monday, November 05, 2012 7:37 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 10:01 PM
Points: 2,944, Visits: 10,504

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 »

Permissions