Below are the principle and mirror scripts I have used in the past. I don't have the witness script to hand but will upload it if you cannot fill in...

Excellent article. Looking forward to more like it !!!!! 🙂

If you need restricted access, think about a new install of SQL; maybe as a named instance on the existing machine.

Set the SA password to be something obscure - see...

You will need to ensure that you have the /PAE (and maybe /3GB) switch in your boot.ini file and you have set the Enable the Lock Pages in Memory Option.

If...

This is quick and dirty way to create an empty table ... Not one to file under best practice though 😎

select * into tablebackup12212009 from table where 2=1

This may be too simple for your situatiion but you can archive data rows using a new table and an update trigger.

Basically, when an update is made to a table,...

Firstly, can I suggest you create a specific file share for your backups. Why? It gives clarity to its use and the $ Shares should not be used for day-to-day...

Do you mean in the DMZ of the firewall or really outside the firewall? :w00t: I hope it's the former ...

I would look to place the SQL Server inside the...

Sometimes you just have to trust people who have more power than you ...

You can also try to bribe the server guy with doughnuts/cake/hobnobs/tea/coffee and ask him to show you...

Without site of the code or a screenshot of the maintenance plan, we are all just guessing as to why the files are not being deleted. Perhaps the poster can...

Check the permissions for the account used to run the SQL Server service as this sounds like it is missing create permissions for the target directory. I encountered this a...

The file created by the backup can be placed in any location that the job account has access to. This includes local drives, iSCSI targets and network shares ... 😉

Just...

The code below will give you a time and date stamp down to the second. It's not pretty but you could make a function out of it.

An example of the...

Interesting ... I am going to assume that you will not keep data older that 90 days so here we go with some general tips on performance.

If you are have...

Partitioning the existing table may be a good way forward for you.

Something like:

Create a 3 partition table to hold data newer than 2 days, between 2 and 30 days and...