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...

You get an email which contains the below

Job Name = Staging_Circle.MergeResourceToProcessWithResources

--------------------------------------

Step name = Circle.MergeResourceToProcessWithResources

DB Name = Staging_Database

Run Date = Nov 14 2012 11:08AM

Error = Unable...

http://www.sqlmag.com/article/tsql3/have-sql-server-email-you-error-messages-generated-by-job-failures

You will need to add a step to the end of every job which is got to by the on failure action of the other steps in the job but...

Doh, yeah I missed that part when reading your post, my bad, sorry on that.

Could you not make use of using DBMail instead if your passing over the results of...