SOX gave us a start to prepare for what was to come. As mentioned by all above, we now have the law on our side when we ask for controls,...

GilaMonster (9/3/2008)

---

Keyword filters aren't a very good way of defending against SQL injection.

1) Use only procedures (preferably) or parameterised queries from your front end apps.

2) Ensure that the app user...

george sibbald (7/3/2008)

---

To 'hot'...

Anyone: How can we get Backup Exec to STOP backing up the databases? It completely destroys my strategy of Weekly Full, Daily Differential, Hourly Log.

In some cases I can remove...

Just maybe ... it has to do with sheet music being a form of a programming language.

Have played guitar (folk, 12-string, bass = favorite), as well as accordion, piano, keyboards,...

You will need something like this:

[font="Courier New"]declare @BakFile char(50)

set @BakFile = 'S:\SqlBackups\DbName '+convert(char(8),getdate(),112)+'.bak'

backup database DbName to disk = @BakFile[/font]

Again, this will append Year-Month-Day,...

Sharon,

1) The Weekly Full Backup job, which runs Sundays at 7 pm, has the following steps:

[font="Courier New"]backup database...

nkm129 (4/30/2008)

---

Only thing :- How to append datetime stamp to backup file...

like I want to backup test database in another folder with name having test_20080430...

I tried this but...

nkm129 (4/30/2008)

---

Thanks mike and all other guys who has give grt explaination ...

Only think what is left here...

Steve -

Thanks, and I appreciate your insights and experience. I was surprised at your original comment, and felt that perhaps I was endangering the bank's applications. Good to find out...

ALZDBA (4/29/2008)

---

I always use backup devices and within a cycle (between full backups) have my log-backups incremental.

Only very rare I've noticed backups failing because of the device.

We regulary test pit-restores...

Steve Jones - Editor (4/28/2008)

---

I would never append backups to a file. As the size grows, you increase the chance of bad blocks or corruption and you could invalidate mutliple...

Reply to nkm123 - Sorry, I was not able to reach you via the email you used.

- - - - - - -

>>> "Mike Hinds" 2008-04-24 10:29:16 AM >>>

You...

OOPS!

I had said, 'The job that runs the Full or Diff at 7 pm also runs an INIT on the "DbName.Bak" file' -- WRONG!

The Diff job does INIT on the...

Mh, I have two separate backup files, "DbName.Bak" and "DbName_Log.bak". Each Sunday evening, when I run the Full backup, I add the WITH INIT command, which completely empties the file....