SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Backup
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SKR
Starting Member

Kenya
6 Posts

Posted - 02/04/2013 :  07:59:47  Show Profile  Reply with Quote
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

3761 Posts

Posted - 02/04/2013 :  08:06:52  Show Profile  Reply with Quote
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
Go to Top of Page

SKR
Starting Member

Kenya
6 Posts

Posted - 02/04/2013 :  08:23:25  Show Profile  Reply with Quote
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...
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3761 Posts

Posted - 02/04/2013 :  08:52:01  Show Profile  Reply with Quote
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.
Go to Top of Page

SKR
Starting Member

Kenya
6 Posts

Posted - 02/04/2013 :  09:13:46  Show Profile  Reply with Quote
Thank you James for your input.

Skr...
Go to Top of Page

jakeliu
Starting Member

USA
3 Posts

Posted - 02/27/2013 :  04:11:06  Show Profile  Reply with Quote
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

Edited by - jakeliu on 02/27/2013 04:11:34
Go to Top of Page

gfjfgt
Starting Member

3 Posts

Posted - 04/21/2013 :  23:13:26  Show Profile  Reply with Quote
unspammed
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000