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 |
|
rohitmathur11
Yak Posting Veteran
77 Posts |
 Posted - 2010-03-02 : 05:34:34
|
| Hi,i want to schedule transaction log backup for every 15 minutes ..what steps i need to follow in sql server 2008 management studio .In taks -- backup -- script action to job is not enable --where to check ... |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-03-03 : 15:06:11
|
| create a job and and write:backup log <databasename> to disk='path'schedule job to run every 15 minutes.But before log backup, you must have full backup of the database. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-03-04 : 04:16:43
|
| Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
|
|
|
rohitmathur11
Yak Posting Veteran
77 Posts |
Posted - 2010-03-09 : 01:01:42
|
| Hi,I scheduled tansaction log backup every 15 minutes and set expire after 1 day ..Can we delete these files after 1 day time through sql server 2008 .Like sql server 2008 have such option to delete all file older then 1 day ? |
|
|
|
|
|
|
Transaction log backup