| Author |
 Topic  |
|
|
SKR
Starting Member
Kenya
6 Posts |
 Posted - 02/04/2013 : 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.
Thanks
Skr... |
|
|
James K
Flowing Fount of Yak Knowledge
1730 Posts |
Posted - 02/04/2013 : 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 |
Edited by - James K on 02/04/2013 08:13:45 |
 |
|
|
SKR
Starting Member
Kenya
6 Posts |
Posted - 02/04/2013 : 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
Flowing Fount of Yak Knowledge
1730 Posts |
Posted - 02/04/2013 : 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
Kenya
6 Posts |
Posted - 02/04/2013 : 09:13:46
|
Thank you James for your input.
Skr... |
|
|
|
jakeliu
Starting Member
USA
3 Posts |
Posted - 02/27/2013 : 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.
_________________
runescape gold|wow gold kaufen|diablo 3 gold|Swtor Credits
|
Edited by - jakeliu on 02/27/2013 04:11:34 |
|
|
|
gfjfgt
Starting Member
2 Posts |
Posted - 04/21/2013 : 23:13:26
|
And so i requested the aid of additional diablo 3 gold amazing participant friends, and they told me the most effective way to have enough wow gold to reside a better existence within amazing is as simple as buying wow gold from online wow gold stores. After that my calm as well as pleasant amazing existence begins. I will usually purchase anything Guild Wars 2 Gold I'd like simply to stick to my trustworthy wow gold store.This can be a excellent online wow gold purchase store providing you with a cozy buying environment as well as comfortable circumstances. You will really feel really happy when you shop, as this store is using probably the most secure software program mechanism to ensure the security associated with customer's account as well as financial information. Like a client, you never be concerned about dangers of being scammed or banned GW2 Gold, simply because that will happen impossiblely.We're hoping to last as well as allowing you to Buy Cheap Maplestory Mesos possess a fantastic wow life! You're going to get a great enjoyable! Buying wow gold from this line could make you re-establish your own self-esteem within diablo 3 kaufen pc. Check it out and start your brand-new trip.
. |
|
|
| |
Topic |
|
Backup
