Re-installing Report Server

I had to uninstall Report Server and Report Designer on are
SQL server machine because of bandwidth concerns. Instead, Im installing
Report Server and Report Designer on a different member server. However the
Report databases remain after the uninstall on the SQL server machine. Is
this ok for these databases to remain? Will the new install try and create a
separate set of databases? I've already run RSkeymgmnt utility and saved the
key file. Is there a different procedure to follow in reinstalling on a
different server? By the way no work was done on the first installation, so
these databases really contain no important data.
MarkIf you don't need the databases, you can delete them. You only needed to
save the key file if you were planning to reuse the old database.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark C" <MarkC@.discussions.microsoft.com> wrote in message
news:E80AE112-31C1-4FA0-BFF5-5A6595C339C8@.microsoft.com...
>I had to uninstall Report Server and Report Designer on are
> SQL server machine because of bandwidth concerns. Instead, Im installing
> Report Server and Report Designer on a different member server. However
> the
> Report databases remain after the uninstall on the SQL server machine. Is
> this ok for these databases to remain? Will the new install try and create
> a
> separate set of databases? I've already run RSkeymgmnt utility and saved
> the
> key file. Is there a different procedure to follow in reinstalling on a
> different server? By the way no work was done on the first installation,
> so
> these databases really contain no important data.
> Marksql

Reinstall SQL Sever 2000

Hi all,

I have a server that is missing some important files, and instead of doing process of elimination, I feel it is best just to reinstall 2000.

Now is there a way to reinstall 2000 and just getting the files that the server is missing?

Is there any guidelines or steps for reinstalling 2000 out there?

Thanking you in advance.

LystraDoes anyone have any answers?

Thanks

Lystra|||I have look everywhere in order to get detail for reinstalling 2000, and have come up with anything.

Will I need to uninstall SQL and then install it all over again to get the missing files?

Thanks

Lystra|||You can try to re-install the service pack. That will replace some files, but not necessarily all of them. And if you are missing enough files that SQL Server will not start up in the first place, you may end up having to just uninstall and re-install SQL Server, altogether.

And, of course, you may want to look into restricting the permissions so folks can not accidentally delete these files.|||Thanks for responding.

As for the data files once I uninstall will the files be remove?

Do I need to move the data files of the server??

Lystra|||I have not uninstalled SQL Server many times, so I do not know if the data files are left on the disk. It is best to save off backups of all of your databases (master and msdb included), before you start this sort of thing. Once you are certain you can get all of your data back from any mishap, then you can start trying to get SQL Server off the box.|||True, its always better to keep the upto date backup of the databases and store them in other location until the resinstallation process is completed.

There aren't any defined steps to reinstall just install the CD and continue as specified in the screen. Its better to do it from scracth by uninstalling current version , remot registery referenced keys, reboot the box and then reinstall SQL.|||Hi

I have found a MS Knowledge base article on How to manually remove SQL server 2000 Default, named, or virtual instance.

I help you with the reinstall process.

Article # 290991

Thanks for all your help

Lystra

Reinitilaize without re-sending the data.

Hi.
I have a subsription that needs to be reinitialized because it has been
marked as inactive. Instead of reinitializing and then have to transfer
a new snapshot, that would caus all sorts of key violations, i would
like to do the following.
1.Drop the subscription.
2.Add subscription with option that the subscribers has the schema and
data.
3.Copy the pending transactions
The problem is, when you drop the subscription, the pending
transactions are truncated, so the question is.
How can i copy all the commands from the distribution agent, that is
supposed to go to a specific subscriber, so that i can just connect to
the subscriber and run them manually after i have set up the new
subscription?
Also have a second question.
We don't have a lot of changes, and it seems like having the log reader
running contuniously is not neccessary. Can i just change the log
reader job to run on a reccuring schedule with Enterprise Manager?
Than you!
The simplest solution is to drop the subscription, use DataCompare or
TABLEDIFF to sync up the tables then do a nosync initialization.
Generally the log-reader is set to run continuously. There are 2 main
reasons I can think why this is so - lower latency and minimise the size of
the transaction log (the log can't be truncated until it's been read by the
logreader).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Do a no-sync subscription. Then run a validation to determine which tables
are out of sync. Then it is a matter of getting these back in
synchronization. You can use tablediff or RedGates data compare for this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<jostein.solstad@.gmail.com> wrote in message
news:1164794648.383493.68110@.14g2000cws.googlegrou ps.com...
> Hi.
> I have a subsription that needs to be reinitialized because it has been
> marked as inactive. Instead of reinitializing and then have to transfer
> a new snapshot, that would caus all sorts of key violations, i would
> like to do the following.
> 1.Drop the subscription.
> 2.Add subscription with option that the subscribers has the schema and
> data.
> 3.Copy the pending transactions
> The problem is, when you drop the subscription, the pending
> transactions are truncated, so the question is.
> How can i copy all the commands from the distribution agent, that is
> supposed to go to a specific subscriber, so that i can just connect to
> the subscriber and run them manually after i have set up the new
> subscription?
> Also have a second question.
> We don't have a lot of changes, and it seems like having the log reader
> running contuniously is not neccessary. Can i just change the log
> reader job to run on a reccuring schedule with Enterprise Manager?
> Than you!
>

reindex versus maintenance plan

Hi,
I would like to reindex all the tables in my database by using a job
instead of a maintenance plan. In a maintenance plan this is possible with
the checkbox: "reorganize data and index pages". How can I do the same thing
in a script without using DDBC REINDEX for every table?Can use sp_msForEachTable system procedure for the same. Like
EXEC sp_msForEachTable 'DBCC DBREINDEX (''?'')'
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Jo Segers" <segers_jo@.hotmail.com> wrote in message
news:%23pu65zeIEHA.1944@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I would like to reindex all the tables in my database by using a job
> instead of a maintenance plan. In a maintenance plan this is possible with
> the checkbox: "reorganize data and index pages". How can I do the same
thing
> in a script without using DDBC REINDEX for every table?
>
>|||Thanks,
This solved my problem.
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> schreef in bericht
news:ePhnW9eIEHA.3376@.TK2MSFTNGP09.phx.gbl...
> Can use sp_msForEachTable system procedure for the same. Like
> EXEC sp_msForEachTable 'DBCC DBREINDEX (''?'')'
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>
> "Jo Segers" <segers_jo@.hotmail.com> wrote in message
> news:%23pu65zeIEHA.1944@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > I would like to reindex all the tables in my database by using a job
> > instead of a maintenance plan. In a maintenance plan this is possible
with
> > the checkbox: "reorganize data and index pages". How can I do the same
> thing
> > in a script without using DDBC REINDEX for every table?
> >
> >
> >
>|||Here is what I use to dbcc indexDefrag all indexes each night:
--***********************************************************************
DECLARE @.Table sysname
DECLARE @.Indid Int
DECLARE cur_tblFetch CURSOR FOR
SELECT Table_Name from information_Schema.tables where table_type = 'base
table'
OPEN cur_tblFetch
FETCH NEXT From cur_tblFetch INTO @.Table
While @.@.FETCH_STATUS = 0
BEGIN
DECLARE cur_indFetch CURSOR FOR
SELECT indid FROM SysIndexes WHERE id = Object_ID(@.Table) AND keycnt > 0
OPEN cur_indFetch
FETCH NEXT FROM cur_indFetch INTO @.Indid
WHILE @.@.FETCH_STATUS = 0
BEGIN
IF @.Indid <> 255
BEGIN
DBCC INDEXDEFRAG(Creditnet,@.Table,@.Indid) WITH NO_INFOMSGS
END
FETCH NEXT FROM cur_indFetch INTO @.Indid
END
CLOSE cur_IndFetch
DEALLOCATE cur_IndFetch
FETCH NEXT FROM cur_tblFetch INTO @.Table
END
CLOSE cur_tblFetch
DEALLOCATE cur_tblFetch
EXEC sp_updatestats
--***********************************************************************
cheers,
Greg Jackson
PDX, Oregon