How are you wanting to test failover? Is it just point your client applications at the server and see if it can connect and read data or will you...

You can restore the logs in a standby/readonly method when creating the logshipping plan, just ensure you enable the disconnect users option to kick anyone out when it tries to...

After you assign the mail profile to the alert system in the agent properties you need to restart the SQL Agent so that it picks up the updated config.

You shouldnt need to take any services offline, it should all be done seamlessly.

If you do want to take services offline for piece of mind, then just stop SQL as...

Ensure you have a good backup of anything which resides on that LUN, just incase the worst happens.

Typically the SAN guy should add the extra space into the LUN and...

The problem is that your expecting to store the file size of the actual physical file into your table which is not what your getting. What your getting is...

Are you writing to the same file on each backup run?

GilaMonster (11/15/2012)

---

anthony.green (11/15/2012)

---

Appreciate that but if the 10pm transaction log was still to recent to restore to the 10:30pm full backup then I assumed that the full backup is ealier...

GilaMonster (11/15/2012)

---

This.

A backup that starts at 10:30 and finishes at 11:30...

If they can only ever be 0 or 1 then max will do the job, as if anything is set to 1 it will return 1 or if everything is...

SQL 2005 or SQL 2008?

You would use the hidden property of the parameters based on the value selected by the open/closed parameter.

Use an expression like

=IIF(Parameters!OpenClosed.Value = "Open", TRUE, FALSE)

You will need to ensure that...

If your using an aggregate function in the select, you need to put in a group by clause of all the columns which are not encased in an aggregate

SELECT name,...

Create a Role using CREATE ROLE

Then grant execute on the functions to the role GRANT EXECUTE ON .... TO rolename

Then add the user to the role sp_addrolemember rolename,...

Why...