|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/30/2010
Posts: 1
Location: Australia
|
Hi
I have .bak files being created for SQL Express 2005 but I am curious why the backup program does not backup the log files,I assume the full backup taken in .bak format has not committed the transaction logs to the database, I could be wrong as I dont know much about SQL and just worried data could be missing after a restore, thanks
Wayne
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
By default our program creates a full backup. http://msdn.microsoft.com/en-us/library/ms175477.aspx"A full backup contains all the data in a specific database or set of filegroups or files, and also enough log to allow for recovering that data." However, you can setup your job to create the differential backup or the transaction log backup. Please see this topic: http://sqlbackupandftp.com/forum/yaf_postst25_What-are-SqlBackupAndFTP-commandline-options.aspx
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
thanks Alex, I am wondering why there is an option there to backup the logs then if the full backup does it anyway
Regards
Wayne
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
Log backups are more advanced topic than you probably need. In other words if you don't know what they are for, you shouldn't worry about them. Full backup will get you all the data up to that point in time. The simplest way to restore is to use One-Click SQL Restore
|
|
|
|
|
