Does the ReportServer on the secondary server has any reports deployed?

To be on the safer side you need to backup that even nothing exists and something exists, I would...

My initial assumption was the same,...

Deos that internal application report use the SS Report Server? You better check the resport server by looking at the Reportserver Report Manager and see for any reports deployed.

Based on...

Hope nothing else goes wrong Lynn. Wishing them both a quick recovery.

edtraviles (12/29/2009)

---

Sorry - I was referring to Gail's reply, when I added my second post. I hadn't seen Bru's reply at that point. Either way (script or GUI), I presume...

Read the article below and post your question accordingly, it would result in better, quicker and tested replies.

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

Yes that's right.

Gail is right.

Alternately, I suggest you take a look at the backup script below.

BACKUP DATABASE [DBNAME]

TO DISK = N'X:\DBNAME_Full_DDMMYY_Time.bak'

WITH NOFORMAT, NOINIT,

NAME = N'DBNAME-Full Database Backup',...

Are you using Reporting Server ? If yes you need to restore them both.

Before doing it, read the article below.

Moving a Report Server Database to Another Computer

Glad to hear that Gus. Congratulations and a Happy New Year in advance 🙂

SSIS has a control flow task called "Transfer Jobs Task" it should help you achieve what you need.

Yes you can.

The only restriction I know and and am aware of is that a backup from a higher Version cannot be restored on an earlier version. Like 2008 DB...

May be, I have not worked on Sharepoint, but MOSS usually indicates that.

lobbymuncher (12/29/2009)

---

GilaMonster (12/28/2009)

---

Why not, Gail? You do this with other people's servers all over the...

Do you have a restriction of doing this using SP's only not any other way.

If SP's only you have 2 choices, search online for SQL scripts to backup all Databases...