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

Restore .ndf file Expand / Collapse
Author
Message
Posted Friday, February 21, 2014 1:28 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
Hi all

we have a database we want to restore this database in another server here we have 10 .ndf files i am trying to restore the backup but it is not working.

what is the process for restoring the .ndf files
Post #1544173
Posted Friday, February 21, 2014 1:41 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:33 PM
Points: 42,818, Visits: 35,943
Define 'not working'?

If you have a full database backup, there's nothing special that needs doing, at most all the files need the WITH MOVE clause, but nothing different between mdf and ndf there.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1544177
Posted Friday, February 21, 2014 1:49 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
Yes, i have the full backup file and moved to new server but i dont know the restoration process can we restore using gui mode or through commnads

i tried through Gui it is not working please advise
Post #1544183
Posted Saturday, February 22, 2014 3:07 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 15,661, Visits: 28,050
You can restore through the GUI or through T-SQL commands, but you'll have to get everything set correctly. If there are 10 data files that define this database, you need to ensure that all 10 files have a WITH MOVE command to move them to appropriate storage locations on the new server (assuming the drive layouts are different). You can look at the backup file itself to identify the logical file names so that you can use WITH MOVE. This link describes how to get that information. This link shows basic restore processes, including WITH MOVE.

To get better help, please post actual error messages. Just saying "it doesn't work" over and over doesn't help us. There are large numbers of places where things can go wrong and we're not sitting at your desk to see what you see.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1544242
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse