You will need to build in a clear down routine to remove files older than so many days.

Again Ola's scripts include this by passing in a value to the CleanupTime...

Probably not, depends how long ago the transaction log backup was last run.

But it still sounds like your backing up to 1 big file and not individual files.

Can you post...

Breaking things is a good way to learn as you need to fix them, so you learn what not to do and what to do should it happen.

Granted would break...

You dont need to do steps 1 and 3 as that wont do anything except break the log chain.

If you have somewhere big enough to store the backup.bak file, move...

Beatrix Kiddo (2/12/2013)

---

Coincidentally I was just reading that article and was coming back to edit my post, but too late!

Is everything else ok though, apart from the need to set...

Also what other indexes do you have on the tables asside from the Primary Keys?

One way

declare @table table (id int, narration char(3), renewalcount int, renewed int)

insert into @table values

(1,'ABC',1,0),

(2,'ABC',1,0),

(3,'ABC',0,0),

(4,'PQR',1,0),

(5,'PQR',0,0)

SELECT

t1.ID,

t1.Narration,

t1.RenewalCount,

t1.Renewed

FROM

@table t1

INNER JOIN

(

SELECT

MAX(ID) AS MaxID,

Narration

FROM

@table

GROUP BY

Narration

) AS t2

ON

t1.ID = t2.MaxID

Replicate into another database on ServerA the data that you want to send.

Back it up, send it to ServerG for ServerB to see, then do regular transaction log backups and...

Logins and password

Jobs

SSIS Packages

Any cross database queries

Backup routines

etc, etc, etc

Can you give more information about why your decommisioning the DB and the steps already taken?

Perfom a full backup, offline the database, see who screams, if no one screams after...

Jeff Moden (2/11/2013)

---

anthony.green (2/11/2013)

---

I dont know of any off the top of my head, but I do have a private FTP server on a dyndns lookup to my ISP in...

Remove "Allow multiple values" from the parameter.

What is your authentication method to the SSRS server? Annoymous, forms, basic, windows?

You need to ensure that you use the connect authentication method to access the SSRS webservice.

You will need a distribution list creating in the mail server which contains the users you want to send a mail to.

I dont know of any off the top of my head, but I do have a private FTP server on a dyndns lookup to my ISP in the UK if...