May 28, 2011

Mssql management studio issues – DB in general

Database,

Error while opening Mssql 2005 management studio MMC could not create the snap-in.MMC could not create the snap-in. The snap-in might not have been installed correctly.Name: Microsoft SQL Enterprise ManagerCLSID: {00100100-1816-11D0-8EF5-00AA0062C58F} Fix Run the following command as shown to fix this. Make sure you have installed the Msql in the path as shown or change…

Read more
May 28, 2011

Backup all MSSQL databases

Linux General,

You can use the below stps to backup all your mssql database at ease. We at actsupport, provide backup solution. 1. Log into your server through Remote Desktop Connection. 2. Open SQL Server Management Studio and select the server name 3. Click the New Query button and enter in the following data: DECLARE @name VARCHAR(50)…

Read more