You will need to install SQL Server 2005 as a named instance, so that it does not conflict with the existing installation.
Hi You will have to use a scale out deployment. See this documentation: Configuring a Report Server Scale-Out Deployment...
I have changed the Index de-fragmentation process, so that indexes are alway rebuilt and never reorganised. I also shrank the Transaction log file...
Hi Guys Sorry that I have taken so long to respond, but I have been investigating my problem a little more, trying to get my head around what is...
Hi The transaction log file for our production database is growing during the weekly job we run to de-fragment the indexes. The job executes the...
SELECT name, physical_name, size, max_size, growth FROM sys.master_files WHERE name = 'templog' Change "tempdb" to the logical name of the...
Hi Rohit Nope, it was a straight restore from a backup file, using NTBackup. The initial backup was of the C: drive and system state, with SQL...
Finished: All up it took us about 8 hours to complete the re-configuration. Most of that time was spent waiting for backups to complete, data to...
Done [:)] This is a very important step for us, everyone who uses the system has already been emailed and we are taking the server down after...
I have obtained a test server that I will use to test my approach today, I haven't carried out a test yet. I am documenting my plan and the...
I have seen this recommended quite a lot, and I know that there is a read/write performance benefit in going for a stripe set instead of a mirror,...
Hi Everyone, this is my first post here. [:)] This weekend I am re-configuring the RAID configuration on our database server running Windows Server...
Separate names with a comma.
