Viewing 15 posts - 586 through 600 (of 2,496 total)
Reporting Services for SQL 2000 was a separate component with its own install process. It will also need IIS installed for it to work.
Best of luck in finding the...
August 6, 2013 at 9:13 am
This should work. We have had to do the same process to increase the size of some of our AWS EBS disk sets.
Also, for AWS we have decided it...
August 5, 2013 at 6:19 am
Separating the data and log files are a company policy
Once upon a time this policy did not exist. Then it got created.
You need another company policy that says 'Leave...
July 30, 2013 at 2:48 am
If you are running on Windows 2008 or Vista or above, then the Administrator account has two sets of authorities. This is built in to Windows and you cannot...
July 30, 2013 at 2:39 am
DB mirroring cannot work due to the latency. This is cross site. sql edition is enterprise.
Asynchronous mirroring will work over any distance.
Your choices are limited by the technology available and...
July 15, 2013 at 3:23 am
Work out the risks of your approach and the risks of other approaches, and discuss these with your manager. Part of your manager's job is to approve the work...
July 15, 2013 at 3:06 am
How did your Windows instances get created? Did someone do a Windows install, a Sysprep type install, or simply clone an existing system.
If your system was cloned from a...
July 9, 2013 at 8:50 am
We use SQL P2P replication to provide scale-out, high availability, and resilience. It does what it says on the can.
There are some warnings in the P2P documentation about quiescing...
July 5, 2013 at 3:37 am
Sounds like you had a problem while the Setup Support Files were being installed. Until this process has got near finishing you do not get any log files.
The most...
July 3, 2013 at 3:44 am
The high-risk approach is to shut down the servers, move them to the new DC, then start them up. It can be done, and I know of organisations that...
June 26, 2013 at 6:31 am
If your licences are under Software Assurance then you are bound by the SQL 2012 licensing rules even if you are running an older version of SQL Server.
You...
June 26, 2013 at 6:18 am
Do you manage both Windows and SQL Server, or is there somebody else who manages Windows at your organisation.
If someone else manages Windows, then ask them to set up the...
June 26, 2013 at 6:08 am
As others have said, running mixing non-Production and Production on the same server is a bad idea.
One of the main issues is Governance. It is established good practice to...
June 25, 2013 at 7:48 am
The main way to speed up index rebuilds is don't do them if they are not needed. Ola Hallengren http://ola.hallengren.com/ publishes an index rebuild routine used around the world...
June 18, 2013 at 2:38 am
The SQL Server install process will always put about 3GB of files on to the System drive. Most of this is .Net routines that must be stored in the...
June 17, 2013 at 3:33 am
Viewing 15 posts - 586 through 600 (of 2,496 total)