InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 15:46:41 GMT20http://www.sqlservercentral.com/Forums/Topic1386052-1550-1.aspxThank youWed, 21 Nov 2012 11:25:22 GMTarkiboyshttp://www.sqlservercentral.com/Forums/Topic1386052-1550-1.aspx[quote][b]arkiboys (11/19/2012)[/b][hr]1- if the backup of transaction log is scheduled to run say every 15 minutes then how can I "write to a new file each time with a unique name" ?[/quote]Your backup script would use the timestamp to form part of the filename. It's common to append the database name, backup type and timestamp to form the backup filename.E.g. a log backup run on Noddy database at 15:34pm would generate a file calledNoddy_TLog_20121119_153400.trn[quote][b]arkiboys (11/19/2012)[/b][hr]2- restoring each transaction log sinice the previous midnight seems to be a long process. How about introducing a differential backup?[/quote]Now your learning, good idea ;-)Mon, 19 Nov 2012 09:33:48 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1386052-1550-1.aspx[quote][b]arkiboys (11/19/2012)[/b][hr]2- restoring each transaction log sinice the previous midnight seems to be a long process. How about introducing a differential backup?[/quote]Then you would need to restore the full backup, the latest differential and all log backups from the differential to the point you're restoring to.Mon, 19 Nov 2012 09:26:37 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1386052-1550-1.aspx[quote][b]arkiboys (11/19/2012)[/b]1- if the backup of transaction log is scheduled to run say every 15 minutes then how can I "write to a new file each time with a unique name" ?[/quote]Have a look at Ola Hallengren's SQL Server Maintenance Solution. It's very easy to setup and use. Read and download from:http://ola.hallengren.com/Many DBAs use it.Mon, 19 Nov 2012 09:05:06 GMTwenihalhttp://www.sqlservercentral.com/Forums/Topic1386052-1550-1.aspx[quote][b]Perry Whittle (11/19/2012)[/b][hr][quote][b]arkiboys (11/19/2012)[/b][hr]1-Do you mean to overwrite?[/quote]No, write to a new file each time with a unique name[quote][b]arkiboys (11/19/2012)[/b][hr]2-I am thinking of having t he full backup of the database every mid-night and transaction log backups every 15 minutes.Does this mean if there is a disaster at 11:55 pm, to restore to 11:45 pm I should a) get the previous midnight database backup, b) from that point I have to restore every singly transaction log in order until 11:45 pm?[/quote]Yes, the last full backup and any log backups up to the point you wish to restore to.[/quote]1- if the backup of transaction log is scheduled to run say every 15 minutes then how can I "write to a new file each time with a unique name" ?2- restoring each transaction log sinice the previous midnight seems to be a long process. How about introducing a differential backup?Mon, 19 Nov 2012 07:34:41 GMTarkiboyshttp://www.sqlservercentral.com/Forums/Topic1386052-1550-1.aspx[quote][b]arkiboys (11/19/2012)[/b][hr]1-Do you mean to overwrite?[/quote]No, write to a new file each time with a unique name[quote][b]arkiboys (11/19/2012)[/b][hr]2-I am thinking of having t he full backup of the database every mid-night and transaction log backups every 15 minutes.Does this mean if there is a disaster at 11:55 pm, to restore to 11:45 pm I should a) get the previous midnight database backup, b) from that point I have to restore every singly transaction log in order until 11:45 pm?[/quote]Yes, the last full backup and any log backups up to the point you wish to restore to.Mon, 19 Nov 2012 07:30:54 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1386052-1550-1.aspx[quote][b]GilaMonster (11/18/2012)[/b][hr]Don't append backups to one file. Backups should ideally each to their own file, preferably time-stamped (DatabaseName20121115211501.trn)To restore to a point in time, you need a full backup taken before that point and all log backups since then (not just one of them)[/quote]1-Do you mean to overwrite?2-I am thinking of having t he full backup of the database every mid-night and transaction log backups every 15 minutes.Does this mean if there is a disaster at 11:55 pm, to restore to 11:45 pm I should a) get the previous midnight database backup, b) from that point I have to restore every singly transaction log in order until 11:45 pm?Mon, 19 Nov 2012 07:14:48 GMTarkiboyshttp://www.sqlservercentral.com/Forums/Topic1386052-1550-1.aspxDon't append backups to one file. Backups should ideally each to their own file, preferably time-stamped (DatabaseName20121115211501.trn)To restore to a point in time, you need a full backup taken before that point and all log backups since then (not just one of them)Sun, 18 Nov 2012 10:01:23 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1386052-1550-1.aspxHi,Hi,Our business can afford to loose data up-to one hour.So in-case of say if a table is dropped or a disaster, etc., I would like to be able to recover the data at lease up-to one hour ago.Let's say the database failes at 11:55 pmI am trying to set the scripts of backup and restore of the database as follows:Are the sample scripts correct please? See below:BACKUP------1- Make sure the database recovery is set to full--schedule this script to run every mid-night monday-fridayBACKUP DATABASE AdventureWorks TO DISK = 'C:\AdventureWorks.BAK'GO 2-schedule this transaction log backup to run every 15 minutesBACKUP LOG AdventureWorks TO DISK = 'C:\AdventureWorks.TRN'GO Re-store--------1-RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK' WITH NORECOVERYGO 2-RESTORE LOG AdventureWorks FROM DISK = 'C:\AdventureWorks.TRN' WITH RECOVERY, STOPAT = 'Nov 12, 2012 11:45:00 PM' GOSun, 18 Nov 2012 09:09:11 GMTarkiboys