looks like one of the third party tape backup tools that take a hot backup of SQL databases by temporarily 'freezing' the files and taking a snapshot of them.

I...

jpowers (8/24/2009)

---

george sibbald (8/24/2009)

---

problem I see here is overnight support. What if you need to perform an auditable function whilst on-call to resolve an issue? Two DBAs will need to...

problem I see here is overnight support. What if you need to perform an auditable function whilst on-call to resolve an issue? Two DBAs will need to be contactable. The...

you could do a logical save of data at the table level by using the bcp utility or an SSIS export.

if it helps anyone...................

figures I got installing SQL to a drive other than OS drive (E drive in this case). Note the OS drive will always still be used wherever...

its probably not that simple, would have to run hyperbac in two streams to be sure, The comparisin is adding together the overall run times of the native backups and...

ok, final results.

I decided the only real test was to back up ALL my databases and see if it went through in the available window, and compare to the native...

do it through query analyser using sp_droplogin store procedure. that will leave user in the database but the login will be removed so that ID will have no access to...

getting back into it after my holiday. Its not a bug, vagaries of my environment mean I don't get the performance others are seeing. No clear cut reason for that...

no, you only have to add individual members to the groups in AD. You then define the AD group to sql as a login and People then get their access...

normal practice here would be to create SW domain groups in AD and add these groups to SQL, then add required permissions within SQL to those groups.

then you add invidual...

In this link http://msdn.microsoft.com/en-us/library/ms190016(SQL.90).aspx

where it says

'Log shipping requires SQL Server Standard Edition, SQL Server Workgroup Edition, or SQL Server Enterprise Edition on all server instances involved in log shipping. '

I...

yes

but of course if you are using some enterprise only features on the primary they won't be supported on the secondary, so thats your limiting factor.

This looks correct.

You say this id cannot create stored procs...

I suggest you use the provided log shipping utilities and just schedule the copy job to run with a slight delay, e.g if the backup job runs on the hour,...