Larry Kruse (4/24/2013)

---

Yeah George, I've been trying to get an SSRS instance tied into my Staging database.

When I select to "Add features to existing..." it displays a pull-down with the...

is it there but greyed out?

what permissions do you have?

are you goiung through this process?

new installation or add features to an existing installation

setup support file installation

Installation type - select 'new installation or add shared features'

setup role - sql server...

and you can do this whilst the cluster is running.

SSRS is not cluster aware (sigh). You will need to add a new feature and then create a new instance just for SSRS.

Then you will have to configure SSRS for...

keeping it simple - right click on database - tasks - export data

I would suggest database mirroring

http://msdn.microsoft.com/en-gb/library/ms189852.aspx

thats a big subject and the best answer depends on what the backup server will be used for and what latency you require.

You need to research clustering, database mirroring, logshipping...

good spot.

If you look a the create database statement in msdn it states:

'When a CREATE DATABASE database_name statement is specified without additional size parameters, the primary data file is made...

Hmmm, that should work, make really sure she has diconnected, kill her connections if you have to.

has she logged off and on again from that machine?

those are very small backups . Track it for at least a week and see if you get any huge log backups, these usually occur when re-indexing is done.

and...

ok, we seem to have gone from a 3mb log to a 14GB one overnight. Just change the growth factor but otherwise leave the logs alone. HAve you changed the...

Initial size 3mb? Are you still shrinking the log? If so stop doing that.

Presuming 6GB is your largest log backup personally I would grow the log to 8GB in one...