Browsing articles from "March, 2012"
Mar
22
2012

Event ID: 57860 Source: Backup Exec Type Error Description: SQL error number: “4818”. SQL error message: “Login failed for user ‘domain\userid service account’.

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: […]

Mar
14
2012

Managing and Optimizing Tempdb in SQL Server

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 […]

Mar
12
2012

Troubleshooting transactional replication timeout error in SQL Server 2000

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 […]

Mar
11
2012

Upgrade SQL Server 2000 Active/Active cluster to SQL Server 2005 and Windows 2003 with High Availability

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

Mar
5
2012

SQL Azure – What is missing?

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 […]

Mar
2
2012

ACO0156E Could not load the Tivoli Storage Manager API

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 […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 35 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

March 2012
M T W T F S S
« Feb   Apr »
 1234
567891011
12131415161718
19202122232425
262728293031  

View Post by Categories

%d bloggers like this: