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 |
|
ToolJob
Starting Member
3 Posts |
 Posted - 2011-03-21 : 09:15:03
|
| I was thrown into the soup when our DBA left the company and was assigned his duties until another one is hired. Long story short we have an ERP database that resides on a MS SQL 2005 server. I was checking the server and found FULL backups were being done once per week with differentials running 1 once a day.We want to do a full backup daily per senior management. When I setup a maintenance plan to do a full backup is there anything else I need to know so - if when needed the FULL backup can be restored without any issues.I seen some threads regarding the importance of .LDF transaction log files. Am I to assume with a full back these are being backed up as well? If so, is it correct for me to think the only file I need to restore the backup from is the .BAK file?ThanksJoe Perkowski |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2011-03-21 : 11:15:37
|
Originally posted by ToolJobquote:
if when needed the FULL backup can be restored without any issues.
Providing the full backup was successful there shouldn't be any problems.quote:
I seen some threads regarding the importance of .LDF transaction log files. Am I to assume with a full back these are being backed up as well?
No, these should be backed up separately, I.e. every half hour or whatever time your business will need to recover to in the event of a database failure, but first check the properties of the database to see what recovery model the database is set to, if its simple then t-log backup would not be required.quote:
If so, is it correct for me to think the only file I need to restore the backup from is the .BAK file?
if your scrapping the differential backups then yes-----------------------------------------------Learning something new on SQL Server everyday. |
 |
|
|
ToolJob
Starting Member
3 Posts |
Posted - 2011-03-21 : 12:16:25
|
NeilI went into management studio and did a properties on the database."Last Database Log Backup" = NONEThough I did find a LDF file that was backed up this morning at 400am.I guess this server isn't backing up the log file for this database. I am not sure where or how to do this.How would I create backups of transaction logs for a database in MS SQL 2005?ThanksJoequote:
Originally posted by NeilG
Originally posted by ToolJobquote:
if when needed the FULL backup can be restored without any issues.
Providing the full backup was successful there shouldn't be any problems.quote:
I seen some threads regarding the importance of .LDF transaction log files. Am I to assume with a full back these are being backed up as well?
No, these should be backed up separately, I.e. every half hour or whatever time your business will need to recover to in the event of a database failure, but first check the properties of the database to see what recovery model the database is set to, if its simple then t-log backup would not be required.quote:
If so, is it correct for me to think the only file I need to restore the backup from is the .BAK file?
if your scrapping the differential backups then yes-----------------------------------------------Learning something new on SQL Server everyday.
|
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-03-21 : 13:48:08
|
| Backing up the log != taking a copy of the ldf file.Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
|
|
|
ToolJob
Starting Member
3 Posts |
Posted - 2011-03-22 : 09:06:21
|
GailThanks for the link it was very informative.My question is now how to I backup these logs for my database?I have the full backup job running...I don't know where to look in SQL Server 2005 to backup the transaction log?Do you know of any web links that shows how to backup transaction log?ThanksJoequote:
Originally posted by GilaMonster
Backing up the log != taking a copy of the ldf file.Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP
|
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-03-22 : 09:23:16
|
| How are you doing the full backups?--Gail ShawSQL Server MVP |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2011-03-22 : 10:59:53
|
http://msdn.microsoft.com/en-us/library/ms179478.aspx-----------------------------------------------Learning something new on SQL Server everyday. |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2011-03-22 : 11:03:27
|
Also to check what recovery model you currently have on the database, go to the database properties select option and look at the recovery model.And this article might help you in the future and fill the gaps on what a recovery model is
http://www.mssqltips.com/tip.asp?tip=1497 |
|
|
|
|
|
|
|
|
SQL Server 2005 Newb FULL backup question