Upgrading a SQL Server database should be straight-forward, when you haven't got much of constraints on the application code. In this regard we have blogged previously such as UpgrageTags posts. Here in this post I would like to go with few FAQs that are related to Upgrade process & procedure...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
01-22-2008
Filed under: sql server, database, upgrade, best practices, sa, clustering, database mail, data files, FAQ, gotchas, sqlmail
I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out the reasons). But one thing is sure that SQL Server...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
11-16-2007
Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins
A specific task of importing data from a text file or any data source where heave inserts and updates are involved is quite common scenario in any SQL Server platform. So when you need to perform such actions on regular basis you need what's the best way to import data from text files into SQL Server...