Transaction Log Backup Script issues

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Transaction Log Backup Script issues

13 posts, Page 1 of 2

1 2 »»

Transaction Log Backup Script issues

Rate Topic

Display Mode

Topic Options

Author

Message

ananda.murugesan

Posted Friday, September 26, 2008 5:21 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:19 PM
Points: 823, Visits: 2,405

Declare @FileName varchar(255)
select @FileName = 'D:\BackupDB\Tlog\DVM_DB_Tlog' + substring(convert(varchar(50),getdate(),120),0,11)+'.TRN'
BACKUP LOG [DVM] TO DISK = @FileName WITH NOINIT , NOUNLOAD ,
NAME = N'DVM', NOSKIP , STATS = 10, NOFORMAT , NO_TRUNCATE

pls give me anybody, i need with time this script

for example
DVM_DB_Tlog 2008-09-26 16:50:28.TRN

Post #576687

steveb.

Posted Friday, September 26, 2008 5:39 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 7:42 AM
Points: 2,802, Visits: 7,103

What is the problem you are having with it?

Post #576695

ananda.murugesan

Posted Friday, September 26, 2008 5:53 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:19 PM
Points: 823, Visits: 2,405

TLog Backup has been taken with date, but i need date and time becuse all Tlog overwrite the same file.

as per script file format is
D:\BackupDB\Tlog\DVM_DB_Tlog 2008-09-26.TRN

I want with time as follows
D:\BackupDB\Tlog\DVM_DB_Tlog 2008-09-26 16:50:28.TRN

Post #576706

Buxton69-502449

Posted Friday, September 26, 2008 6:25 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 19, 2009 8:32 AM
Points: 196, Visits: 465

Try using this in part of your script, I don't think you can have a colon (: ) in the file name, that might be the reason it's not working, this should remove the : from the name:

LEFT(REPLACE(REPLACE(CONVERT(VARCHAR,GETDATE(), 120), ' ', '_'), ':', ''), 18)

Post #576733

Rajesh kasturi

Posted Monday, September 29, 2008 12:52 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 12:26 PM
Points: 185, Visits: 725

That is right file name can't have /\:*?"<>|.

Rajesh Kasturi

Post #577544

ananda.murugesan

Posted Monday, September 29, 2008 6:10 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:19 PM
Points: 823, Visits: 2,405

Thanks for reply

i got file format with help of your script,

DVM_DB_Tlog2008-09-29_173509.TRN

.. its ok fine,

Post #577647

ananda.murugesan

Posted Monday, September 29, 2008 6:17 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:19 PM
Points: 823, Visits: 2,405

hi,

could you give me details,

what is different between incremental backup & differential backup in sql server 2000?

Post #577652

Rajesh kasturi

Posted Monday, September 29, 2008 7:30 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 12:26 PM
Points: 185, Visits: 725

As you know we have 3 types of backups available in SQL Server
Full, Differential and Transactional

Incremental backup can be Differential or T-Log.

Rajesh Kasturi

Post #577705

Wildcat

Posted Monday, September 29, 2008 11:52 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 10:10 PM
Points: 307, Visits: 1,390

ananda.murugesan (9/29/2008)

what is different between incremental backup & differential backup in sql server 2000?

SQL SERVER does not have incremental backup.

But, the Windows OS does have.;)

Post #577893

Rajesh kasturi

Posted Tuesday, September 30, 2008 3:38 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 12:26 PM
Points: 185, Visits: 725

Hi Wildcat,
Could you please tell me what is meaning of incremental backup weather it is in OS or sql server.

Rajesh Kasturi

Post #578157

« Prev Topic | Next Topic »

13 posts, Page 1 of 2

1 2 »»

Permissions