amitwadhawan (7/6/2011)

---

I have a very small database size , i am trying logshipping, we are taking full backups nightly and sending them to remote location on remote server where ...

This link contains details about snapshots and how they work

yes, also bear in mind to have a read only mirrored database you need to use snapshots which you may or may not be comfortable with

you can extend the mirroring timeout and thats about it. Log shipping is better if you want a scheduled movement of the data and you can have it read only...

No!

Adam Angelini (9/10/2008)

---

2. if the above scenario is not possible, since it seems to want unique virtual names, then can you have several...

you can also delete the current backup before taking the new but this is not recommended for obvious reasons

The following will set the max server memory to the value you specify in MB's

exec sp_configure 'show advanced options', '1'

reconfigure

exec sp_configure 'max server memory (MB)', 'set this'

reconfigure

exec sp_configure 'show advanced...

thats the max size the...

No it doesn't, changing the recovery model from Full or Bulk Logged to Simple...

are you able to send a test email with no attachment?

Execute the following and post the full results, not just a subset

EXECUTE msdb.dbo.sysmail_help_account_sp

😀 especially if some monkey pulls the plug or holds the power button in for 4 secs 😉

on a high traffic database how many transactions could take place in the space of a minute or even five minutes??

Have you ever wondered why when you shut down SQL...

Please tell me you are...

Jayanth_Kurup (7/5/2011)

---

But setting the recovery interval would make sure it runs frequently enough to make sure the recovery doesn't exceed the time limit specified.

Also, i wasn't able to find...

A faster shutdown, but a sloooooooooow startup 🙂