.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Server migration help is required

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :ASP.Net

Hi all,


We will be migrating SQL Server from 2000 to 2005 in near future  , we have created the Jobs for automatic emails in sql server 2000

kindly suggest me important points regarding data migration with jobs


Suggestions are welcomed

Best Regards


View Complete Post

More Related Resource Links

sql server 2005 enterprise edition is required


sql serve 2005 enterprise edition is required to work with microsoft enterprise blocks


SharePoint Enterprise Search Migration Tool for SharePoint Server 2010

Use this tool when you upgrade to SharePoint Enterprise Search to migrate search-related data, such as best bets, search scopes, and site collection search settings.

Why upgrade is required from SQL Server 2000 to SQl Server 2008

Hi all Can some body share with information about "Why upgrade is required from SQL Server 2000 to SQl Server 2008?"   This question was raised by my Boss why upgrade is required.   I stared saying   My: there is no more   support for SQL Server 2000 from Microsoft   Boss: what you will do  as DBA, Why Required Microsoft support   My: 2008 having very good features where 2000 not have...like Compression, resource governing. .Etc..   Boss: do you mean Database backup compression take full backup and compresse it using ZIP   Finally He (Boss) told me that give document proof why I have go for SQL Server 2008 and what down time you required?   Some body help me why really SQLServer 2008 is required and what are benefits   I have a link; please provide your greatest ideas so that I can convince my Boss.   http://www.mssqltips.com/tip.asp?tip=1462   share your greate Ideas please....   Thanks in Advance     SNIVAS

Server-side validation on an Entity Framework required field (property) does not work!

Has anyone had issues getting server-side validation on an Entity Framework required field (property) to work? The data type is a string (nvarchar). Server-side validation for required fields of other data types WORK fine. Only string fields have issues. I get the following error on UpdateModel(obj); of my POST method within the controller. Exception Details: System.Data.ConstraintException: This property cannot be set to a  null value.Source Error: Line 4500:                OnTextChanging(value);Line 4501:                ReportPropertyChanging("Text");Line 4502:                _Text = StructuralObject.SetValidValue(value, false);Line 4503:                ReportPropertyChanged("Text");Line 4504:                OnTextChanged(); I've even tried data annotations like this but it seems to get ignored.     [MetadataType(typeof(ObjMD))]     public partial class Obj     {    

Server ERROR: An error occurred during the parsing of a resource required to service this request.

I have created one asp.net 2.0 application and created a setup project. I run this setup in my local machine, the application run fine, but i uploaded into online server I met the following parser error.How to solve this error? Kindly help me. Very urgent.. Kamal....

why runat="server" attribute is required for ajaxcontroltoolkit controls?

the doubts i have may looks silly,i started my carrier in dotnet recently,1)we are calling them as client side controls,then what is the need for runat server attribute?2)<asp:Button ID="Button1" runat="server" Text="Button" /> <asp:ConfirmButtonExtender ID="Button1_ConfirmButtonExtender" runat="server"              ConfirmText="Really?" Enabled="True" TargetControlID="Button1">  </asp:ConfirmButtonExtender>when i execute the above code,i observed that in status bar message as "connecting to localhost",if they are client side controls what  is the need of going to local server,why it is happening?Thanks in advance.

Health Analyzer reports "Product / patch installation or server upgrade required." and I can't seem

The text of the error is: On server SHAREPOINTSERVER, once all required products and/or patches are installed, perform an upgrade by either running PSConfigUI.exe or by executing the command "PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures". If a former upgrade attempt has failed, you may need to resolve upgrade specific issues before attempting upgrade again. Refer to the upgrade status page (http://sharepointserver:XXXX/_admin/UpgradeStatus.aspx) for information about current and prior upgrade attempts, and to determine issues that may be preventing upgrade from succeeding. For more information about this rule, see "http://go.microsoft.com/fwlink/?LinkID=142700". So I went to the server in question and ran the command line quoted in the error message and then I get this error back: Configuration of SharePoint Products failed. Configuration must be performed before you use SharePoint Products. For further details, see the diagnostic log located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\1 4\LOGS\PSCDiagnostics_....log and the application event log. So fine, I look into the event log and get this: Failed to initiate the upgrade sequence. An exception of type System.IO.IOException was thrown. Additional exception information: Access to the path 'C:\ProgramData\Microsoft\SharePoi

Exchange Server 2007 SP1 mailbox migration into 2010

Hi Everyone, I’ve got all in one Exchange Server 2007 SP1 RU3 that got all in one role installed (HT-CAS-MBx) in Windows Server 2003 Standard R2 SP which is also running as domain controller with all FSMO role. I’m planning to migrate the Exchange Server 2007 server role into the Exchange Server 2010 Standard that I have prepared in my Virtual Machine of Windows Server 2008 R2, what is the safest migration path to make the email flow working end to end parallel (staging migration process). [B](please also not that this Exchange Server 2007 SP1 got so many problem like – OOF email error in Outlook 2007, meeting scheduler stopped working, etc… therefore updating it into SP3 is not the way here and I've backed up the mailbox using Backup Exec 2010 in case i can just restore the backed up mailbox into the new server 2010 if possible)[/B] My this is what I’m about to do: 1. Transfer all FSMO role into another domain controllers 2. Install and configure similar role in the new VM (Exchange Server 2010 Std.) 3. Confused… Things to do after all mailbox migration: 1. Cutover the MX record into the new server name 2. Install updated UCC- SSL certificate into the exchange server 2007 Any kind of help and suggestion would be greatly appreciated. Thanks, AWT /* Infrastructure Support Engineer */

Membership migration from MS Access to MS SQL Server

Dear all,I want to migrate membership data table from Access to SQL Server but I got a problem about Data type.Do you know some topic what is related with it or somebody can did it?Thank you,

Migration of DSN use for SQL Server access from Windows SP-3 clients to Windows 7 64 bit client

We have numerous apps which use a named DSN using SQLSRV32.dll for an ODBC connection from our Windows XP-Pro SP3 32 bit machines client access to remote windows 2003 based SQL servers (mix of 2005 and 2008).  On migrating to Windows 7, this dll will not allow the apps to use the newly constructed DSN (using SQLSRV32.dll with ODBC), even though a test connection is sucessful (abbeit much slower than seen on the XP-Pro machines).  What must I use on the Windows 7 64 bit machine to allow a DSN to be used by the migrated apps?  - I have descerned through Google that WDAC is now the tool to use, but I am cluless how to use it. - The expectations from the app on the Windows XP-Pro and on the Windows 7 64 bit machines is to use a DSN to connect to SQL servers on Windows 2003. I would appreciate any advice, and thanks!

Product / Patch installation or server upgrade required in Health Reporting area

Via PSCDiag Log I get ERR Task upgrade has failed with an unknown exception ERR Exeception: Microsoft.SharePoint.Upgrade.SPUpgradeException: Action of Microsoft.SharePoint.Upgrade.SPIiswebsSitewssSequence Failed--->System.DirectoryServices.DirectoryServicesCOMException (0x80070003): The system cannot find the path specified.

Setup of SQL Server 2008: Restart required but I have restarted

Hello,I have tried to install SQL Server 2008. I cannot install, because I get the errormessage the prerequistite "Restart the computer is required".But every time I restart my computer and try to execute the setup of SQL Server 2008, I get the same message, I have to restart the computer.I cannot install the SQL Server 2008. What can I do?Thanks


Hi All, Yesterday we installed SQLSERVER 2008 R2 in our development mechine , and already it have Microsoft TFS 2008. When i open my report project it came up with the upgrade messagebox i clicked on Yes.And i try to run the reports locally its giving me exception like "An attempt has been made to  use the data extention 'custom datasource extention 1.2' that is eaither not registered for this report server or is not supported in this edition of reporting services'.So i did the changes like adding the dlls into the reportserver bin and added the data block which i have configured for SSRS 2008 i have applied the same setting for the SSRS 2008 R2 but still i am gettign the same exception do we need to do any changes in SSRS 2008 R2. because i am able to run the reports sucessuflly in SSRS 2008 but not SSRS 2008 R2? Any body have ideas on this. Thanks, Veeren.

MSDTC - TransactionOption "Required" works from my XP Workstation but not from our 2008 Server

I have a SSIS package (2008) that has a sequence container with TransactionOption Required.  This is needed to ensure that multiple tasks commit or fail together.  It also has a custom transformation that establishes (acquires) connection objects. This package works great when run from my local XP workstation.  I can see the distributed transaction starting and committing in the SSIS output. The problem is that when I roll this package out to the server, it fails to acquire the connection, throwing an error at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectinoMAnager100.AcquireConnection(Object pTransaction).  I've verified that the security settings of MSDTC on this server are consistent....they are definitely set to allow inbound and outbound. Are there any issues with MSDTC on Windows Server 2008?  Is it possible that I'm getting an issue because my workstation is 32 bit but the server is 64 bit? Thanks -Mark

Error in SQL server 2000 after the migration (internal query processor error)

I just moved a couple of databases from one instance of SQL 2000 from different hardware to SQL 2000 instance of other hardware and after the move from the application side the app team gets an error -2147217900 - Internal Query Processor Error: The query processor could not produce a query plan.  Contact your primary support provider for more information.', 'E', '2UA929041X. Does any one have any idea about this. I took a trace while they were testing and I found out this in the trace. exec usp_DlyPrc_LogProcessEvent '-2147217900 - Internal Query Processor Error: The query processor could not produce a query plan.  Contact your primary support provider for more information.', 'E', '2UA929041X An idea or direction on this will be greatly appreciated. Thanks hash

Setup failed to install the required component Microsoft SQL Server 2005 Express (MSSMLBIZ)


I Don't understand what this means: Everytime I try and install the disc 2 of my Office Small Business 2007, it gives the same message.  Help.


Microsoft SQL Server 2005 9.00.3042.00
OS Version      : Home Edition  (Build 6000)
Time            : Tue Jul 03 17:14:45 2007
Machine         : SWANNER-PC
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install         : Failed
Log File        : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0005_SWANNER-PC_SQLSupport_1.log
Error Number    : 1618
Machine         : SWANNER-PC
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install         : Failed
Log File        : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0005_SWANNER-PC_SQLNCLI_1.log
Error Number    : 1618
Machine         : SWANNER-PC
Product         : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install         : Failed
Log File        : c:\Program Files\Microsoft SQL Ser

Issue with SAN Drive Migration in master database in clustered SQL Server 2005 SP1




In our SQL Server 2005 SP1 cluster, I have to retire the existing SAN and move all my databases to new SAN drive. I have successfully moved all datafiles (user,system databases, resource) except master database.


Even when I change the parameters in start-up from configuration manager, I am getting error when starting up from cluster administrator / configuration manager.


But I am able to start the SQL Server successfully from command line (without any flags).


When I start the SQL Server from cluster administrator / configuration manager (after changing the parameters), I see that the start-up parameters are changing back to originalpath (old SAN) .


Please let me know incase you need any more information.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend