reportservertempdb

We are working on creating a copy of our SQL server machine for disaster
recovery purposes. ReportServerTempDB is purely a temp database, correct?
Meaning, the data in it does not need to be replicated from our production
server to our disaster recovery server, correct?
Could someone just verify this for me.
Thanks.Yes, you don't need to replicated your ReportServerTempDB
According to BOL "Backup and Restore Operations for a Reporting Services
Installation"
The only reason to backup the reportservertempdb is to avoid having to
recreate it if there is a hardware failure.
Med bouchenafa
"Jeff" <Jeff@.discussions.microsoft.com> a écrit dans le message de news:
C440E7E5-D027-4C98-9A8B-EA0C8C2B245B@.microsoft.com...
> We are working on creating a copy of our SQL server machine for disaster
> recovery purposes. ReportServerTempDB is purely a temp database, correct?
> Meaning, the data in it does not need to be replicated from our production
> server to our disaster recovery server, correct?
> Could someone just verify this for me.
> Thanks.|||Depends... are you talking disaster recovery... in which you would
re-establish services from a repository of stored data? ...or... are you
looking for fault tollerance where a more real-time fail over takes place
imediately after the falure due to disaster?
"Jeff" wrote:
> We are working on creating a copy of our SQL server machine for disaster
> recovery purposes. ReportServerTempDB is purely a temp database, correct?
> Meaning, the data in it does not need to be replicated from our production
> server to our disaster recovery server, correct?
> Could someone just verify this for me.
> Thanks.|||Ken,
We're looking a the former. We have an offsite repository of data, which we
would use to re-establish services in the event of a fire or something like
that. This isn't for real time failover.
"Ken Carter" wrote:
> Depends... are you talking disaster recovery... in which you would
> re-establish services from a repository of stored data? ...or... are you
> looking for fault tollerance where a more real-time fail over takes place
> imediately after the falure due to disaster?
> "Jeff" wrote:
> > We are working on creating a copy of our SQL server machine for disaster
> > recovery purposes. ReportServerTempDB is purely a temp database, correct?
> > Meaning, the data in it does not need to be replicated from our production
> > server to our disaster recovery server, correct?
> >
> > Could someone just verify this for me.
> >
> > Thanks.