The column Is_Copy_Only is backupset.

But forget that comment, Diff backups cannot be made in a copy_only state

http://msdn.microsoft.com/en-us/library/ms191495.aspx

Your full backups though could be created as copy_only and therefore will not allow...

The diff backups in question are not "copy only" backups are they?

Is_copy_only from msdb.dbo.backupset

Scott D. Jacobson (8/20/2012)

---

anthony.green (8/20/2012)

---

Scott D. Jacobson (8/17/2012)

---

anthony.green (8/17/2012)

---

run query in ssms, results to grid, right click top left hand blank thing to select the whole result set including headers,...

Data file more than 90% full, find big tables and delete data no longer needed, add more space to the file, as a counter measure check the auto growth settings...

Scott D. Jacobson (8/17/2012)

---

anthony.green (8/17/2012)

---

run query in ssms, results to grid, right click top left hand blank thing to select the whole result set including headers, then right click, save...

Take a look at Ola's scripts in my signature, he has a good comprehensive maintenance script which will do what you want.

Nope, we need to give the users direct access to the web page, so rendering to file is not an option.

As this is going to be external facing SSRS and...

To add on to this, if you go in via ReportServer and browse via that URL the reports render as HTML. It is only if you go in on...

Change the function to return varchar(max) and have a str of varchar(max)

Follow the instructions on this link http://technet.microsoft.com/en-us/library/dd207004.aspx

Make sure you are a local admin of the server where SQL is installed.

Then once the above has been done and SQL is in...

You need to grant the nessesary access to your account, so you will need to login as an account which has the right access to change user permissions.

Typically your DBA...

What have you tried so far?

And does it need to be a total of all databases per month,

E.g

200GB July 2012

Or does it need to be broke down by DB

20GB...

run query in ssms, results to grid, right click top left hand blank thing to select the whole result set including headers, then right click, save results as

MSDB you probably wont have any problems with, but master you might as thats the "server" db, unsure if there would be some flag or data in master to say...

bitbucket-25253 (8/16/2012)

---

Be very, very careful about using ISNUMERIC .. for example, altering your input data slightly to more readily see the possible problem.

DECLARE @Codes TABLE (Code VARCHAR(100),LineNr...