Viewing 15 posts - 6,316 through 6,330 (of 9,253 total)
Run DBCC UPDATEUSAGE against one of the databases and then te run CHECKDB, let us know how you get on.
October 27, 2011 at 1:35 am
Ed Zann (10/26/2011)
the default database is scripted out for the login, so it must exist on the destination or the statement will error out and not create the login.
This is...
October 26, 2011 at 12:01 pm
yes the installer is still the same
October 26, 2011 at 10:10 am
from memory go to Control Panel > Programs > Programs & Features. Select SQL Server 2005 and click change
October 26, 2011 at 9:58 am
spidey73 (10/26/2011)
The strange thing is that from the 11 databases (including the system dbs) the same 5 always fail.
Have these databases come from a legacy\previous version of SQL Server?
October 26, 2011 at 8:44 am
there's a nasty bug in the sp2 installer which if i remember correctly doesnt affect the sp3 installer.
with sp2 you cant run the installer and patch only the one node....
October 25, 2011 at 10:46 am
what service pack is the live instance currently at?
October 25, 2011 at 10:13 am
i've already answered this in your duplicate post 😉
October 25, 2011 at 10:12 am
when you configure log shipping the alert jobs are created for you.
Please post the full results of the following executed against your secondary instance
sp_help_log_shipping_monitor_secondary
@secondary_server = 'secondary_server',
@secondary_database = 'secondary_database'
October 25, 2011 at 8:50 am
hmm, you should always uninstall the clustered applications if possible before evicting the node. I would go for a clean install and then re introduce the node and re install...
October 25, 2011 at 8:45 am
if the node was previously a member and was evicted cleanly then there shouldnt be any reason why you cant re introduce the server, although i always prefer a clean...
October 25, 2011 at 8:11 am
carefully run through the change setup paying attention to the options offered, it should become fairly obvious 😉
October 25, 2011 at 7:21 am
no, not the active node because SSRS is not cluster aware. Go to Add\Remove programs on the node where you want to uninstall the instance and select Change.
During setup you...
October 25, 2011 at 6:49 am
itsamarnath (10/25/2011)
Both the instances are configured for reporting services.
Now, the client wants us to uninstall reporting services from one of this...
October 25, 2011 at 6:35 am
Viewing 15 posts - 6,316 through 6,330 (of 9,253 total)