Thursday, June 24, 2010, 08:14 AM - Microsoft SQL Server, Microsoft SQL Server
Issue:
SQL Server Management Studio is slow while starting.
Solution:
The management studio can not find a certain URL. This can be fixed by adding the following line to the hosts file:
127.0.0.1 crl.microsoft.com
| permalink | related link |
Tuesday, January 5, 2010, 10:22 AM - Microsoft SQL Server, Microsoft SQL Server
Issue:
The backup of the full database fails with error number -1073548784.
Solution:
Most likely the database requires a log file backup before a full backup is possible.
To see if the log file backup is required, select the following:
select log_reuse_wait_desc from sys.databases where name='your database name';
If this displays 'LOG_BACKUP', then first execute a transaction log backup. After the transaction log backup, the full backup should be possible again.
| permalink | related link |
Tuesday, January 5, 2010, 07:39 AM - Microsoft SQL Server
Issue:
The disk containing the tempdb from SQL Server 2005 is near full.
Solution:
The tempdb can be moved by executing the following SQL and restarting the SQL Server instance:
USE master;
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev, FILENAME = '{location}tempdb.mdf');
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = templog, FILENAME = '{location}templog.ldf');
GO
| permalink |
Friday, December 25, 2009, 11:06 AM - Microsoft SQL Server
Issue:
You are trying to implement database mirroring with SQL Server 2005 instructions from http://weblogs.sqlteam.com/tarad/archive/2007/02/13/60091.aspx and fail at:
CREATE ENDPOINT [Mirroring]
AS TCP (LISTENER_PORT = 5022)
FOR DATA_MIRRORING (ROLE = PARTNER, ENCRYPTION = ENABLED);
Solution:
The keyword ENCRYPTION=ENABLED should be ENCRYPTION=SUPPORTED
| permalink | related link |
Wednesday, November 4, 2009, 06:44 AM - Microsoft SQL Server
Issue:
A Microsoft SQL Server standby database needs to be brought online.
Solution:
Execute the command:
restore database [databasename] with recovery;
on the database server where the standby database is running.
| permalink |
Monday, October 19, 2009, 10:26 AM - Microsoft SQL Server, Microsoft SQL Server
Issue:
The user rights assignment in SSIS is difficult to configure in such a way that a user does not require (local) administrator rights to be able to use SSIS.
Solution:
The following steps are required:
1. Add the user to the Distributed COM Users group using Administrative tools->Computer management->System tools->Local users and groups->groups->Distributed COM Users;
2. Open Control Panel, double-click Administrative Tools, and then double-click Component Services to start the Component Services MMC snap-in;
3. Expand the Component Services node in the left pane of the console. Expand the Computers node, expand My Computer, and then click the DCOM Config node;
4. Select the DCOM Config node, and then select MsDtsServer in the list of applications that can be configured;
5. Right-click on MsDtsServer and select Properties;
6. In the MsDtsServer Properties dialog box, select the Security tab.
7. Under Launch and Activation Permissions, select Customize, then click Edit to open the Launch Permission dialog box;
8. In the Launch Permission dialog box, add or delete users, and assign the appropriate permissions to the appropriate users and groups. The available permissions are Local Launch, Remote Launch, Local Activation, and Remote Activation. The Launch rights grant or deny permission to start and stop the service; the Activation rights grant or deny permission to connect to the service. Here select Local Activation only;
9. Click OK to close the dialog box;
10. Under Access Permissions, select Customize, and then click Edit;
11. In the Access Permission dialog box, add or delete users, and assign the appropriate permissions to the appropriate users and groups. Here select active Local & remote access;
12. Click OK to close the dialog box;
13. Close the MMC snap-in;
14. Restart the Integration Services service.
| permalink | related link |
Wednesday, December 3, 2008, 10:38 PM - Microsoft SQL Server, Microsoft SQL Server
Issue:
You are expecting certain options in the maintenance cleanup plan (like option to select sub directory level for cleanup), and the option is just not there at one database, while it is present at another database.
Solution:
The problem is being caused be a mismatch in the SQL Server management Studio and the SQL server installation. Upgrade the SQL Server management studio to be at the same version of the SQL Server installation and the problem should disappear.
| permalink |
Sunday, March 23, 2008, 02:15 PM - Microsoft SQL Server
Issue:
You are trying to grow a Sequoia (giganteum) from seed (germination) and do not know how to do this.
Solution:
The shopping list:
- Buy standard plant soil at your local garden center;
- Buy breakable plastic pots, organic pots or be prepared to kill of your flower pot when the tree grows, diameter pot about 8 cm at the top;
- Buy a germination hothouse (about 20 cm high is a nice size) with some ventilation holes, and possibility to mount a light on it;
- Buy a small light (bulb/tube: Bulb if outside since it also gives sufficient warmth, 6 to 10 watts light is enough);
- Some aluminium foil for reflecting the light.
The planting:
1) Mount the lamp onto the hothouse;
2) Coat the inside of the hothouse bottom and the sides (until halfway the height of the hothouse) with aluminium foil=> Reflection increases the efficiency of the light, so 6 to 10 watts of light is enough;
3) Take the pots and fill them to the top with soil, do not compress the soil;
4) Add a generous amount of water to the soil;
5) Put some seeds on top of the soil (about 5 per pot);
6) Put very little (1 to 2 millimeter) soil on top of the seeds;
7) Add a bit more water;
8) Put the pot(s) into the hothouse;
9) Place the pots inside your house;
10) Plugin & turn on the light. Leave the light on for about 18 hours per day (longer is allowed unless it disturbs you).
About 2.5 to 3 weeks are between sowing the seeds and the first sequoia emerging using a surrounding temperature of about 15 to 20 degrees Celsius.
If the inside of the hothouse fogs up to much, you can clean it.
Occasional sunlight will help the process (and makes it possible for you to turn of the light)
Notes:
A small percentage of seeds really grows into tiny sequoias with even less of those surviving the first year. Expect about 25% to grow with this method.
| permalink |
