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 2000 Forums
 SQL Server Administration (2000)
 Restore database

Author  Topic 

dewacorp.alliances

452 Posts

Posted - 2007-08-15 : 01:42:33
Hi all

If I do the:

RESTORE FILELISTONLY FROM DISK = 'F:\temp\WAITING_FOR_DELETE\XXXX_db_200708031511.BAK' and is there anyway to restore with specifiying the size of TLOG cause sometimes the tlog get larger size.

Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-15 : 22:47:40
No, have to shrink log file in source db then backup again.
Go to Top of Page
   

- Advertisement -