I have Transactional Replication running between 2 DBs on the same server, Publisher,Subscriber and Distributor are on the same server. We are moving...
the MSDB log is about 15 GB whereas the data file is only 6 GB. Is there a way to shrink the MSDB log? Thanks
We are going to move the report services DBs to a faster SAN within the same SQL server machine. Which would be the best way to do it? I was...
One of our developers left the company and we had to reactivate his Windows Account so the Reports he created in SQL Reporting Services wouldn't...
We have a SSRS 2005 Installation using the Standard Edition and the DB hosted in an Active/Passive cluster environment. I want to scale-out my report...
I have a DB that unexpectedly grew from 245 GB to almost 340 GB (90 GB growth) in a day and I haven't been able to figure out what caused it. I...
I am pretty much confused as to what to do; According to MS http://msdn.microsoft.com/en-us/library/ms345193.aspx, the disadvantages in making SSIS...
Are there any specific guidelines to make SQL Server PCI Compliant, specially if your company collects credit card information?
Initially I had created a Perf Counter Log job that would save it to a text (csv) file. Recently I decided to start saving the information to SQL...
I have been collecting information about 20 performance counters (memory, IO, cpu, SQL) that refresh every 15 seconds; would that have any...
We have our production SQL 2005 server (64 bit Standard Ed.) attached to an iSCSI Equalogic SAN. We have set up 2 new servers and installed the...
Our company needs to be "CPI compliance" complianced realy fast. I have gone in the web and I have been bombarded by all king of information. I have...
I have gotten mixed comments on this topic. I have a 64 bit machine running 64 windows 2003 standard and 64 SQL 2005 standard with 8 GB of RAM. We...
I am running SQL 2005 Standard under Windows 2003 Standard with 8 GB of RAM in one of our 64 bit servers; I noticed min server memory was set for...
I would like to increase the initial size of a SQL 2005 DB from 150 to 250 GB to prevent automatic autogrowth; would this have any impact in...
Thanks for your reply Brad
I have a SQL 2005 DB that its MDF file is growing at a rate of 1 GB per day, I currently have it set up to unrestricted growth by 500 MB. Should I...
I need to reset the password of the domain account sql services are running under. Is there any known issue I should be aware of ? Should I restart...
I am trying to restore master to a new server but location of data and log files is different in this new server. The previous location was...
we are trying to simulate a disater recovery of our SQL2000 development servers. Which is the order in which we should restore the DBs. I am talking...
Separate names with a comma.
