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.
| Author |
Topic |
|
SKR
Starting Member
6 Posts |
 Posted - 2013-02-04 : 07:59:47
|
| Hi all,I am new in SQL server forum, I just want to know how to take a full database backup including all logs, so that I can restore the database upto the point of failure.your help is appreciated.ThanksSkr... |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-02-04 : 08:06:52
|
| In SQL Server Management Studio, in Object Explorer, right-click your database name and select Tasks -> Backup. The dialog that comes up gives you options on back up type, location of backup and all other kinds of stuff. You can also do backups using T-SQL Scripts. If you are curios, after you have made the changes, click the script button on the top left of the dialog. That will generate a script for you. You don't have to do this - you can do the back up just by using that dialog.You can also take periodic log backups to avoid having to take the full backup. Then you will be able to use a full backup together with the log backups to restore to the point in time of the last log backup.Also, this page would be useful: http://msdn.microsoft.com/en-us/library/ms175093(v=sql.90).aspx |
 |
|
|
SKR
Starting Member
6 Posts |
Posted - 2013-02-04 : 08:23:25
|
| Hi James,Thank you for your quick reply. So you suggest to take full database backup once and then periodic log backups, and in case of recovery I need to restore the full backup and then log backups. what about the changes made in between my last log backup and the DB failure? will there be online logs ? to recover the DB upto the point of failure?Skr... |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-02-04 : 08:52:01
|
| I don't think you can achieve that reliably with just a single server and backups alone. You would need to use some technology such as transactional replication, database mirroring, or failover clustering. Paul Randal's white paper here is a great resource: http://msdn.microsoft.com/en-us/library/ee523927(v=sql.100).aspx He also has couple of video tutorials on the same topic. |
|
|
|
SKR
Starting Member
6 Posts |
Posted - 2013-02-04 : 09:13:46
|
| Thank you James for your input.Skr... |
|
|
|
jakeliu
Starting Member
3 Posts |
Posted - 2013-02-27 : 04:11:06
|
| Then you will be able to use a full backup together with the log backups to restore to the point in time of the last log backup.unspammed |
|
|
|
gfjfgt
Starting Member
3 Posts |
Posted - 2013-04-21 : 23:13:26
|
| unspammed |
|
|
|
|
|
|
|
|
Backup