SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


database restore file name


database restore file name

Author
Message
sqlfriends
sqlfriends
SSCertifiable
SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)

Group: General Forum Members
Points: 5085 Visits: 4087
I tried to use SQL management studio to restore database from one server to another server. They are both sql server 2005.

When I restore I want to check if the file path is correct, so I click option tab, then I can see database file logical names, and the file path. The thing I noticed different is the log file name. I remember sometime before when I did restore the default log file name is mydb_log.ldf, but now it is something like mydb_1.ldf. I can certainly change the name to _log. But I remember it used to be default like that. Is this anything new? Or I missed something.

Thanks
maechismo_8514
maechismo_8514
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2254 Visits: 2228
The logical file name should not change unless explicitly changed by someone. Is it just yourself who run this server?
sqlfriends
sqlfriends
SSCertifiable
SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)

Group: General Forum Members
Points: 5085 Visits: 4087
It's not logical name.

What I mean is the physical file name.
DHeath
DHeath
Mr or Mrs. 500
Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)

Group: General Forum Members
Points: 503 Visits: 650
is it possible that your database has more than one file to it.. or a file in the past that was deleted and then readded? By default you are correct it should be _log.

Good Luck

DHeath
sqlfriends
sqlfriends
SSCertifiable
SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)

Group: General Forum Members
Points: 5085 Visits: 4087
Thank you.
I can see in the original server we only have one ldf file for that database, it is called mydb.ldf. we never deleted or added before.

But on the new server, when I move/restore, on the option tab, the file path is database default location, the file name one is mydb.mdf, the log file is mydb_1.ldf.

I think it may try to create the same name, only extensions are different. Since there is already a file with the same name, it tried to create _1 file, instead of _log.

I didn't see this before. The only difference is the new server is a windows 2008, the old OS is windows 2003.
The sql server version are the same though.

I think I will just have to manually change the name to _log. Thanks
maechismo_8514
maechismo_8514
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2254 Visits: 2228
But why does it matter to you though whether is it _log or _1??

Why don't you restore using the TSQL?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search