Viewing 15 posts - 31 through 45 (of 64 total)
If you just want to eliminate your fears ... then at this point i would suggest going through the monitoring scripts given in this white paper
go with a structured approach...
August 26, 2009 at 4:39 pm
Please provide your topology/architecture ... how many publishers, distributors and subscribers ...... what is the sequence you are planning to restart them ???
generally replication does come back up pretty fine...
August 26, 2009 at 4:21 pm
it would not start until the previous run is finished .... you could test this out on a test box to have a working select statement and then a waitfordelay...
August 26, 2009 at 3:34 pm
this does not help ... please read http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 26, 2009 at 2:46 pm
well .... as per licensing goes ... this could lead to a Windows Data Center Edition kind of a solution. You pay a huge sum, but the OS comes bundled...
August 26, 2009 at 2:23 pm
trebor69 (8/26/2009)
We are experiencing a gradual slow down in performance, as SQL memory usage increases, which can only be solved by a re-boot.
if right now you are only using...
August 26, 2009 at 1:12 pm
are you getting any SQL Server memory paged out ? you could check in the error logs for a message like "A significant part of sql server process memory has...
August 26, 2009 at 12:31 pm
http://technet.microsoft.com/en-us/library/ms151870(SQL.90).aspx
this should help
August 26, 2009 at 10:58 am
Then rebuild all indexes to undo the fragmentation that the shrink caused.
Good point ... missed that one :satisfied:
August 26, 2009 at 9:12 am
looks like there is definitely some free space in your data file(s) ..... when you try to restore it through GUI .... do you get to see the files that...
August 26, 2009 at 8:50 am
there is generally no limit to the snapshot replication per say .... but you could be limited by the cache size if the bcp file becomes large ......I have not...
August 26, 2009 at 8:35 am
as you say that the code was the same on old server ... so i assume that also had a link server setup on the same server....
at this point...
August 26, 2009 at 8:21 am
dmiller (8/25/2009)
for the database converted from Access to SQL/2005 it returns "The login already has an account under a different user name." And same error launching the application.
sounds like...
August 25, 2009 at 3:45 pm
JonJon (8/25/2009)
I have about 3.75GB of memory.
I dont think PAE and AWE need to be enabled ... or What am i thinking :doze:
August 25, 2009 at 3:32 pm
Viewing 15 posts - 31 through 45 (of 64 total)