BACKUP LOG databasename TO DISK = 'C:\filename_LOG.bck'
Once you have the transaction log backed up you can then restore both your full backup and your transaction log backup.
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig deeper on SQL Server Backup and Recovery
Restore backups in SQL Server 2000 and SQL Server 2005 with this command.continue reading
Back up tables from a SQL Server database to a file with these commands.continue reading
Find out how to restore data from a corrupt database.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.