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

database restore file name Expand / Collapse
Author
Message
Posted Wednesday, April 1, 2009 12:34 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 3:18 PM
Points: 1,773, Visits: 3,207
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
Post #688277
Posted Wednesday, April 1, 2009 1:01 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
The logical file name should not change unless explicitly changed by someone. Is it just yourself who run this server?

Post #688294
Posted Wednesday, April 1, 2009 1:15 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 3:18 PM
Points: 1,773, Visits: 3,207
It's not logical name.

What I mean is the physical file name.
Post #688303
Posted Wednesday, April 1, 2009 1:30 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 5:42 PM
Points: 209, Visits: 641
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
Post #688311
Posted Wednesday, April 1, 2009 1:48 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 3:18 PM
Points: 1,773, Visits: 3,207
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
Post #688318
Posted Wednesday, April 1, 2009 1:57 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
But why does it matter to you though whether is it _log or _1??

Why don't you restore using the TSQL?

Post #688324
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse