June 30, 2014 at 5:32 am
Dear All,
Am using 2008 and 2012 in my System.
I have Question like the following.
In 2008 i have taken the Full backup and can restored that Backup into the New Database without changing the Mdf,Ldf names and path.
Same thing when am trying to do in 2012 its throwing error msg, But if i change the Mdf and Ldf names then i can able restore the database.
If I want to Restore same like 2008/2008R2 what should i do in 2012.like i dont want to change the Path,Mdf and Ldf Names.
Pls help me out..
PFA...
Regards
Chowdary...
June 30, 2014 at 5:42 am
it sounds like all the instances(2008, 2008R2, and 2012) are all on the samemachine.
you will absolutely have to change the path or filename in order to have more than one copy of the database. each instance is trying to use the same filename, which it inherits as a default path from the backup, and you'll have to change it...i'd recommend simply renaming the mdf/ldf to WorldCup2008.mdf or something to help you identify the isntance it is sitting inside of. the name of the .mdf has no affect whatsoever on the functionality.
i typically segregate my instances filesout explicity, you know, d:SQLData\2008 vs D:\SQLdata\2012 and then i have Data\Backup\Log folders beneath them.
Lowell
June 30, 2014 at 5:48 am
Chowdary's (6/30/2014)
Dear All,Am using 2008 and 2012 in my System.
I have Question like the following.
In 2008 i have taken the Full backup and can restored that Backup into the New Database without changing the Mdf,Ldf names and path.
Same thing when am trying to do in 2012 its throwing error msg, But if i change the Mdf and Ldf names then i can able restore the database.
If I want to Restore same like 2008/2008R2 what should i do in 2012.like i dont want to change the Path,Mdf and Ldf Names.
Pls help me out..
PFA...
The restore is attempting to use the original filenames from when the backup was taken. Go to the "Files" page of the restore GUI and under the "Restore As" section supply database filenames that more closely reflect the new database name. (for example WorldcupTest.mdf and WorldcupTest.ldf)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2014 at 5:57 am
Thank you for giving the Reply Mr.Lowell
As i am using the Same system it may creates some problem i agree with you,
But i had checked in other system which is having only 2012 in that also same problem am getting.
Actually My Boss don't want to change the name or path so what can we do for this.
Can you pls share something.
Regards
Jagadeesh....
Regards
Chowdary...
June 30, 2014 at 5:58 am
Chowdary's (6/30/2014)
Thank you for giving the Reply Mr.LowellAs i am using the Same system it may creates some problem i agree with you,
But i had checked in other system which is having only 2012 in that also same problem am getting.
Actually My Boss don't want to change the name or path so what can we do for this.
Can you pls share something.
Regards
Jagadeesh....
See my reply above 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2014 at 6:00 am
Dear Whittle Thank you very much for giving the Reply.
If i change the Names of Mdf and Ldf from the Files page i can able to restore the Database successfully but without changing the names is there any chances? Am searching in Google but i didn't find any.
Regards
Jagadeesh....
Regards
Chowdary...
June 30, 2014 at 6:17 am
Chowdary's (6/30/2014)
Dear Whittle Thank you very much for giving the Reply.If i change the Names of Mdf and Ldf from the Files page i can able to restore the Database successfully but without changing the names is there any chances? Am searching in Google but i didn't find any.
Regards
Jagadeesh....
You can' have a database on 2008 and a database on 2012 both pointing to the exact same file name and file path. That's the problem. The files must be in a different location.
"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
June 30, 2014 at 7:23 am
Hi Mr.Garnt Thank you for the Reply.
Actually am checking the server which is having only 2012.There am getting the issue.
Pls help me out if there is any chances...
Regards
Jagadeesh....
Regards
Chowdary...
June 30, 2014 at 7:29 am
Chowdary's (6/30/2014)
but without changing the names is there any chances?
If you change the folder path then yes.
I'm assuming you understand the concept of files and folders within a filesystem???
The filename must be unique with that directory, put the file into another directory, a sub directory for instance and that will be acceptable.
It would be more prudent to name the files to match the database name so they're more easily identifiable.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2014 at 8:09 am
Chowdary's (6/30/2014)
Hi Mr.Garnt Thank you for the Reply.Actually am checking the server which is having only 2012.There am getting the issue.
Pls help me out if there is any chances...
Regards
Jagadeesh....
As long as you have unique file names on a given server, yes, you should absolutely be able to restore them to the second server. You may need to use the WITH MOVE command to take into account that the path to the file is different between the servers. Here's an article that covers that.
"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
June 30, 2014 at 8:40 am
Grant Fritchey (6/30/2014)
As long as you have unique file names on a given server,
It's not the server dictating this. You can have 100 databases all with the primary filename bob.mdf, as long as they're all in different folders that the database engine has control over that's fine.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2014 at 9:13 am
Perry Whittle (6/30/2014)
Grant Fritchey (6/30/2014)
As long as you have unique file names on a given server,It's not the server dictating this. You can have 100 databases all with the primary filename bob.mdf, as long as they're all in different folders that the database engine has control over that's fine.
Sorry, should have been more clear, within a given path.
"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 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply