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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Transaction Logs

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-12-31 : 08:12:29
Santosh writes "Hi,

I am new to your site.

My query is is there any way we can take continuous transaction log backups just like informix ?
We are having sql 7.0 with sp2.

Thanks in advance

Santosh"

Nazim
A custom title

1408 Posts

Posted - 2003-12-31 : 09:27:00
you can create a backup job and schedule it for a particular interval.

look in BOL for Jobs , there is a step by step guide for creating and doing other actions on jobs.



-------------------------
What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson
Go to Top of Page
   

- Advertisement -