Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dalim.ghosh
Starting Member
11 Posts |
 Posted - 2009-07-11 : 08:58:21
|
| I have Backup(SQL Server 2005)how can i know the MDF & LDF file name & their location from backup itself |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-07-11 : 09:00:01
|
| restore filelistonly from disk='path of backup file'MadhivananFailing to plan is Planning to fail |
 |
|
|
dalim.ghosh
Starting Member
11 Posts |
Posted - 2009-07-11 : 09:40:28
|
| I want to know the name of MDF & LDF file from backup (.bak) file itself |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-11 : 10:09:20
|
| Madhivanan just showed you how. try it |
|
|
|
dalim.ghosh
Starting Member
11 Posts |
Posted - 2009-07-11 : 10:17:50
|
Thanks a lot it's workingquote:
Originally posted by madhivanan
restore filelistonly from disk='path of backup file'MadhivananFailing to plan is Planning to fail
|
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-07-13 : 02:17:11
|
quote:
Originally posted by dalim.ghosh
Thanks a lot it's workingquote:
Originally posted by madhivanan
restore filelistonly from disk='path of backup file'MadhivananFailing to plan is Planning to fail
Well. You are welcome  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Logical & Physical name