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 |
|
sqldba2k6
Posting Yak Master
176 Posts |
 Posted - 2007-07-11 : 18:27:46
|
| I need a scripts which should back up the databases and delete the transaction file after 10 days... |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-07-11 : 18:39:36
|
| You should look at Tara Kizer's blog. She has a number of administration scripts there that should be a good starting point for what you want to do.http://weblogs.sqlteam.com/tarad/CODO ERGO SUM |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-11 : 22:40:23
|
| You can do that with maintenance plan. |
|
|
|
sqldba2k6
Posting Yak Master
176 Posts |
Posted - 2007-07-12 : 13:22:18
|
| Can you please tell me the steps..for deleting the transaction log |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-07-12 : 13:50:16
|
quote:
Originally posted by sqldba2k6
Can you please tell me the steps..for deleting the transaction log
I don't know what you are trying to do, but "deleting the transaction log" is probably not what you need to do.CODO ERGO SUM |
|
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-07-12 : 13:54:31
|
| http://sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=LDF,Log,File____________________________________________________________________________________"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide |
|
|
|
|
|
|
Administration scripts 200