>Dear Experts,
>
>We have Systems with MS SQL 200 and I need very good suggestions on how can i back up this. My superior request to make backup evry 30mins.
>
>ANy particular Machine or backup solutions you can suggest.
You have to set up a log shipping to a second instance of SQL. It could be the same server or another server. This will act as a READ ONLY db until you switch it over to use. Now that doesn't mean you can query it, it's in single use mode for the continual acceptace of new trransaction logs that it digests.