Slightly off topic, but I could not understand much of what was asked. It wouldn't hurt much to enusre you at least make sense when asking for help......

Thanks for that 🙂

Now to build the scripts .... :hehe:

But how would I maintain only 2 days backups locally while I maintain a months worth of backups on a the remote backup server ??

flugelbinder

Hi Prakash I have thought about that and have actually built that at my last place of employment with great sucsess. In the long run I will be going...

and dont run your anti-virus on you'r prod server.

Thanks for all the replies.

When I say zero data loss I understand you can never garuntee this but can do what ever nessasary to minimize data loss, with the standard...

Good article, thanks.

GSquared (2/17/2009)

Sisyphus move over! New guy with version 2.0...

Usually that is a Windows Domain account and not a sql account.

That is the solution that has been thrown around, have the 3rd part Co run Profilier and send me the output. I was hoping to be able to look at...

That is  very much along the lines of what I need, however to trow a spanner in the works, I am in a tight bind..

I am the DBA for company...

Tyr something like this....

Declare @id int,

        @name varchar (50),

        @cnt int

Declare getallrecords cursor local static For

 Select count (1), id, name

   from contact (nolock)

   group by id, name  having count(1)>1

Open getallrecords

Fetch next from...

This is a clasic, however i feel it very important to include for want of a better title ' The Jargon Speaker' you knwo the ones, who at any  meeting they...

Harnessh

It sounds like you have no more room to gorw in the data file. Now this is either because you have set the max size of the file and have...