Is possible restore only a MDF file from backup file?

Hi,
have a problem, I need restore only MDF file from my backup file named
data.BAK, beacause the LDF file is too big, is possible?
After restore data file, I need create a new empty log file for my db.
thx!I'm afraid not. When you do a RESTORE, SQL Server need to be able to create
the same amount of file, with the
same logical name and the same file size as you had when the backup was take
n.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Luca" <luca_milan@.hotmail.com> wrote in message news:5027603c.0403241209.210d6711@.posting.
google.com...
> Hi,
> have a problem, I need restore only MDF file from my backup file named
> data.BAK, beacause the LDF file is too big, is possible?
> After restore data file, I need create a new empty log file for my db.
> thx!|||Sorry,
I posted below the response for command restore filelistonly, any
suggestion for save this DB, I have only a db_2.BAK file:
db_2_Data|D:\MSSQLDataAndLogs\db_2_Data.mdf D PRIMARY 218693632 35184372
080640
db_2_Log|D:\MSSQLDataAndLogs\db_2_Log.ldf L NULL 54643130368 35184372080
640
Thanks a lot for any Help!!!
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Did you see my earlier post?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"luca milan" <luca_milan@.hotmail.com> wrote in message news:uo862BeEEHA.1272@.TK2MSFTNGP11.p
hx.gbl...
> Sorry,
> I posted below the response for command restore filelistonly, any
> suggestion for save this DB, I have only a db_2.BAK file:
> db_2_Data|D:\MSSQLDataAndLogs\db_2_Data.mdf D PRIMARY 218693632 35184372
> 080640
> db_2_Log|D:\MSSQLDataAndLogs\db_2_Log.ldf L NULL 54643130368 35184372080
> 640
> Thanks a lot for any Help!!!
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||No, sorry,
but I have find a valid MDF file and with sp_attach_single_file_db all
work fine!
Thx
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!