June 4, 2004 at 8:40 am
We are using SQL Litespeed v2609. We have a backup device that contains 2 backups. My question is, if we restore using the basic
exec master.dbo.xp_restore_database
@database =' ',
@filename =' '
And we don't specify the filenumber- what gets restored? Is the default the last backup taken?
I've looked through the Litespeed help file but it does not specify.
Any ideas?
June 7, 2004 at 8:00 am
This was removed by the editor as SPAM
June 7, 2004 at 9:24 am
I found a little time, and an inactive db to do some testing. So for anyone else that runs into this:
If you do not specify a filenumber the query will restore the FIRST backup file that exists in the backup device.
June 11, 2004 at 1:42 pm
You're correct. If the filenumber is not specified in the xp LiteSpeed will default to the first file number in the backup device. I noticed that you are still using 2.6.0.9. Our newest version, SQL LiteSpeed, is on our website and available for download right now. The new build includes more GUI functionality, The ability to generate SQL scripts for backing up and restore in the GUI, backups that can go straight to tape and a ROI tool that is activated in evaluation mode.
We've also added to our product suite and we have several more products that can be evaluated for free.
Speed Change Manager - Simple, yet powerful, database comparison tool for Microsoft© SQL 7 or 2000 databases. This includes the ability to generate the scripts necessary to make two databases identical.
Speed IDE - Full-featured integrated development environment (IDE) for Microsoft SQL Server 2000 or 7.
Speed Coefficient - Database monitoring and analysis for Microsoft SQL Server 7 and 2000. Statistically analyzes database activity and produces detailed reports.
It's pretty cool technology and definately worth a free test drive.
David Swanson
US Tech Support Manager
Imceda Software
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply