MSKB Article# 842425
[quoted text, click to view] >-----Original Message-----
>We have recently installed new Report Server and now we
need to transfer whole database from one server to
another.
[quoted text, click to view] >Backup/Restore database "ReportServer" doesn't work.
Maybe because old server is without SP1, new server is
with SP1.
[quoted text, click to view] >Documentation recommends to use scripting
utility "rs.exe".
>But I didn't see sample script for transfering whole
database from one server to another.
>Did anyone make that before?
>Anyone has the script(.rss) for transferring whole
ReportServer SQL database "ReportServer" from one
ReportServer to another?
[quoted text, click to view] >I understand that I can make the script by my own, but I
don't think this is a good idea of spending time.
>.
You will need to have both machines be at SP1 (or RTM) to do the backup
restore.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view] "Paul Cyr" <anonymous@discussions.microsoft.com> wrote in message
news:09b701c46e6d$4cf769b0$a501280a@phx.gbl...
> MSKB Article# 842425
> >-----Original Message-----
> >We have recently installed new Report Server and now we
> need to transfer whole database from one server to
> another.
> >Backup/Restore database "ReportServer" doesn't work.
> Maybe because old server is without SP1, new server is
> with SP1.
> >Documentation recommends to use scripting
> utility "rs.exe".
> >But I didn't see sample script for transfering whole
> database from one server to another.
> >Did anyone make that before?
> >Anyone has the script(.rss) for transferring whole
> ReportServer SQL database "ReportServer" from one
> ReportServer to another?
> >I understand that I can make the script by my own, but I
> don't think this is a good idea of spending time.
> >.
> >
