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...
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...
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...
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...
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...
September 25, 2010 at 5:18 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.
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...
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...
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...
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...
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?
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...
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...
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?
September 5, 2010 at 4:35 pm
Viewing 15 posts - 676 through 690 (of 966 total)