February 21, 2014 at 1:28 pm
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
February 21, 2014 at 1:41 pm
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 21, 2014 at 1:49 pm
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
February 22, 2014 at 3:07 am
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[/url] to get that information. This link shows basic restore[/url] 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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply