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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 transaction logbackup

Author  Topic 

jyothiswarup
Starting Member

1 Post

Posted - 2008-02-03 : 04:13:39
i had taken transaction logbackup.but while restoring it is showing that it has data files.

restore filelistonly from disk='D:backup\AdventureWorks_20080203_023423170.trn'

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-02-03 : 11:20:01
Didn't get what you meant...Did you take Full backup?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-03 : 13:48:01
Yes, every db has data file.
Go to Top of Page
   

- Advertisement -