Viewing 15 posts - 676 through 690 (of 966 total)
Please post the summary.txt file that Pradeep asked for. In fact, if you open up the summary.txt file it should tell you the specific component the install failed on and...
Joie Andrew
"Since 1982"
September 25, 2010 at 5:58 pm
I do not have my lab up right now so I cannot test this, but I got this from a 2005 troubleshooting article on TechNet:
Note that the previous query treats...
Joie Andrew
"Since 1982"
September 25, 2010 at 5:55 pm
If you need changes to be reflected immediately, then transactional replication is probably your best bet if the connection is good. Tablediff is not a good choice. Tablediff is meant...
Joie Andrew
"Since 1982"
September 25, 2010 at 5:42 pm
Nope. Sorry, you have to detach/attach. You do not have to do it through the GUI though; you can use SPs to accomplish it if you were wanting to script...
Joie Andrew
"Since 1982"
September 25, 2010 at 5:29 pm
The closest reference I could find to this error was related to a cluster with SP3 installed. You are not on a cluster, are you? If so you can test...
Joie Andrew
"Since 1982"
September 25, 2010 at 5:18 pm
I believe you're out of luck on this one.
Frequently Asked Questions for Replication Administrators
Joie Andrew
"Since 1982"
September 20, 2010 at 3:02 pm
Agreed. You need to either perform a log backup on the database in question to clear the log or grow the log if possible.
Joie Andrew
"Since 1982"
September 20, 2010 at 2:56 pm
That seems fine for a starting point. Depending on your specific needs and work loads the settings may need to be tweaked in the future, but that looks okay to...
Joie Andrew
"Since 1982"
September 6, 2010 at 6:19 pm
You should still set the min/max values for memory in SQL to ensure a couple of things:
- That SQL will not be robbed of a minimum amount of memory to...
Joie Andrew
"Since 1982"
September 6, 2010 at 5:33 pm
All the BOL article is saying is how to perform the same operation as one would through T-SQL but doing it through SSMS instead. It is saying if you have...
Joie Andrew
"Since 1982"
September 6, 2010 at 4:11 pm
If you are running SQL Server 2005 32-bit, even with AWE you are limited to 8GB per instance, and everything above 4GB is limited to the buffer pool, so things...
Joie Andrew
"Since 1982"
September 6, 2010 at 3:58 pm
Do you have to execute the SSIS packages with dtexec? Is there a reason you cannot import the packages into SQL and change the job step to SSIS package?
Joie Andrew
"Since 1982"
September 6, 2010 at 3:41 pm
exec sp_addpushsubscription_agent @publication = N'Products', @subscriber = N'SERVER1', @subscriber_db = N'SubsTesting', @job_login = N'\\Server1\ReplDistAgent', @job_password = null, @subscriber_security_mode = 1, @frequency_type = 8, @frequency_interval = 1, @frequency_relative_interval = 1, @frequency_recurrence_factor...
Joie Andrew
"Since 1982"
September 5, 2010 at 5:32 pm
The problem is that the SQL 2008 box does not have local admins/domain admins a part of the sysadmin database server role by default like previous versions did. This is...
Joie Andrew
"Since 1982"
September 5, 2010 at 4:41 pm
What do you get back from running restore verifyonly on the backup that you are trying to use?
Joie Andrew
"Since 1982"
September 5, 2010 at 4:35 pm
Viewing 15 posts - 676 through 690 (of 966 total)