While check Windows errors logs, came across these errors, solution is already provided by Symantec; basically this error is recieved when any type of backup is run by Backup exec agent on a server having Microsoft SQL Server installed. Details of issue are as below, Solution provided by Symantec at following link: http://www.symantec.com/business/support/index?page=content&id=TECH29539 Problem Event ID: 57860 “An error occurred while attempting to log in to the following server…SQL error number: “4818”. SQL error message: […]

We often come across situations where there is contention in tempdb or tempdb is getting oversized, etc. better planning of tempdb may avoid performance issues if it is being used heavily and also reduce administration effort, below article is basically focussed on the planning stage of tempdb to reduce administration effort and avoid performance issues, Source: http://support.microsoft.com/kb/328551, http://www.sqllion.com/2009/05/optimizing-tempdb-in-sql-server-2005/ Tempdb is one of the system database in SQL Server, all user data is lost from tempdb […]

Timeout error is mostly encountered in merge or transactional replication scenarios where data needs to be synced at regular time intervals, now sometimes due to network issue or bad data replication start failing with timeout errors, now to troubleshoot them follow below steps, Source: http://www.mssqlcity.com/Articles/Replic/troubleshooting_replication.htm and http://support.microsoft.com/kb/312292 First, when you encounter timeout error, go to distribution agent SQL job (in case of push subscription, agent job will be present on distributor server and in case […]

Part 1: Team composition and upgrade option pros and cons – http://searchsqlserver.techtarget.com/tip/Upgrade-Active-Active-cluster-to-SQL-Server-2005-and-Windows-2003 Part 2: Restoring a SQL Server database to a transition server – http://searchsqlserver.techtarget.com/tip/How-to-restore-SQL-Server-database-to-transition-server-during-an-upgrade Part 3: SQL Server high availability when upgrading to SQL Server 2005 – http://searchsqlserver.techtarget.com/tip/SQL-Server-high-availability-when-upgrading-to-SQL-Server-2005 Part 4: Upgrade live applications to SQL Server 2005 for high availability – http://searchsqlserver.techtarget.com/tip/Upgrade-live-applications-to-SQL-Server-2005-for-high-availability Part 5: Monitor database mirroring and replication after upgrade – http://searchsqlserver.techtarget.com/tip/Monitor-database-mirroring-and-replication-after-a-SQL-Server-upgrade

I was reading few articles around Microsoft’s cloud database SQL Azure and found an interesting article Five things in SQL Server not in SQL Azure Below are those five features, Data encryption Physical SQL Server used TDE for data encryption, if your application depends on TDE then you need to find a workaround or implement encryption logic within application, else need to wait for Microsoft to include TDE in Azure in future Full-text indexing and […]

After installing TDPv5.5.1 on SQL Server 2000 as per following link , TDP GUI should work fine, but in case you uninstall and reisnatll TDP client then you may start facing below issue while opening up TDP GUI, In addition to above, you may see other error as below, After researching in IBM documentation, found following link which provides information on this error, ACN0156E: Could not load the Tivoli Storage Manager API. Explanation The Tivoli […]