Script to backup transaction log
How to write a Script to backup the transaction log each hour for some databases in a server and keep the backup files of 1 week old ?.
2004-02-07
3 reads
security
RE: Stored Procedure Use Results from another?
I have explored the use of #Temp, doing an insert on that table takes about 4 secs. for about 11000 rows. However, when I attempt to query up any data that is in #temp from another SP I get no results.The nested SPs may be an option, but I can not find any examples of […]
2004-02-07
RE: Trans log question
I believe that growth is a logged event and if the log is full, then you need to clear space before it can grow. Running a "backup transaction with no_log" will get you space. Then run a full backup before you do anything.
2004-02-03
2004-02-02
RE: Alternative to MRTG?
Are you looking for free or something that you purchase? BMC, NetIQ, others have pay products. I used MRTG, but had help setting it up and it worked beautifully.
2004-02-02
Database Create Date after restore.
I restored from a *.bak to two different servers. The restore was succesful yet the database create date is different. Should this date change? Does the create date update at the time of "define new DB" Does this date ever change without delete and define?Unable to confirm it myself but will keep trying and report back.
2004-02-02
610 reads
SQL Injection!
Do your developers really understand how to prevent injection attacks? Or scarier still, how many know what an injection attack is? Chris has some great examples of how sql injection works and how to prevent it.
2004-02-02
17,123 reads
RE: IE Error Loading Taskpad view in EM
Yes, Staying on the thread Agreed - I don't use EM very often - generally just to use the taskpad view to keep an eye on trans log growth when I am running a monstrous script. But the error the other day threw me off and wondered if there was a resolution to it. No […]
2004-01-30
1 reads
2004-01-30
2 reads
SQL Server Security Part 2
In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.
2019-10-04 (first published: 2004-01-30)
35,249 reads
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers