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


Top 5 Contributors of the Month
ASPEvil
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Post New Web Links

Side by Side installation SQL Server 2005 to SQL Server 2008

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server
 

Hi all

I am moving databases between SQL Server 2005 to SQL Server 2008

1.DBCC CHECKDB(DBNAME)  on SQL Server 2005

2.Full backup of the Database and Restore into SQL Server 2008 with verify Optiom

3.Move the users

4.Run DBCC CHECKDB(DBANME) on SQL Server 2008

5.Run  Re-idexing Job on SQL Server 2008

5.Run updatestatistic job

6.Sign off from installtion..

above I am going to follow is correct or I need to do some thing  more.....

Please suggest me.

thanks in advance

 


SNIVAS


View Complete Post


More Related Resource Links

SQL Server 2008 side -by-side installation in Cluster w2k3 sp2.

  
Hi  I am ready with In-Place and went to Sr.DBA Manager, He rejected and he want 100% Database guarantee and 100% safe, down time does not matter for him and recommended me go a head with Side by Side. 1.If detach Database from SQL2k and attach to SQL2k8,I don't think  it is possible to attach back...is it correct 2. Is it required Create new cluster group for SQL2k8? 3. In 2 case what are the cluster groups I have to Create 4. Is it required to change connecting string from application? 5. If it is where i have to modify the connecting string in application level or in Database server level? 6. What are the settings can I take care after installing new sql server instance?  7. Is it required new virtual instance name for new installation (Instance)? 8.Is there any way to use existing virtual instance name for New instance?(so I belive no Need to change connecting string in application) 10.Is it possible to change instance name?(Old instance name to some other name and new instance name as existing instance name).  SNIVAS

Restoring Databases form SQL Server 2000 and SQL Server 2005 to SQL Server 2008 -Side by Side --he

  
Hi all I Installed SQL Server 2008 R2 in Server and I took backup of all the User databases backup from 2000 and 2005(two instance are running) Now I am doing restore the Databases,while I am restoring I am information icon in bottom of the restore window that is "The Full-Text Upgrade Option server property controls whether full-text indexes are improved,rebuild or reset" that means I have to upgrade full-text indexes or this just inforamtion.If I want find out whither Database using full-text how to check ? once I done this I have to move the users as well.Please dome body share the script you have.   Thanks in AdvanceSNIVAS

SQL Server 2008 R2 Side by Side installation in Cluster(Active/passive on Windows 2003 SP2).

  

Hi all,

I came again with couple question on SQL Server 2008 R2 side by side installation in Cluster(Active/passive on Windows 2003 SP2).


1.I have already have SQL Server 2000 SP4 Installation.
 
2.Can I start Installation(Side by Side) from Passive node ?

3.you want me give New SQL Server Netwrok name (Instance Configuration  Screen)?.

4.you want me give New Instance ID  name (Instance Configuration  Screen)?

5.Can I chose Excixting Clustore resource group or I need to Create New group which is the best ?

 

Thanks in advance


SNIVAS

SQL Server 2005 installation on windows 2008 cluster error

  

I am trying to install SqlServer 2005 on windows 2008 cluster with domain controller. Installation fails on the second node while trying to set registry settings for server network libraries. Attached error message and output from error log. Can somebody suggest any solutions.

Thanks

Ravi

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

Failed to set registry settings for server network libraries. The action is SetDefaults. The error is 11004 (The requested name is valid, but no data of the requested type was found.
)

 

Func Name='LaunchFunction'>
Function=Do_SetServerSSNLDefaults
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_SetServerSSNLDefaults
PerfTime Start: Do_SetServerSSNLDefaults : Fri Sep 24 17:45:31 2010
<Func Name='Do_SetServerSSNLDefaults'>
Setting server network settings for instance name MSSQLSERVER, instance id MSSQL.1
Failed to set registry settings for server network libraries. The action: SetDefaults Error: 11004
        Error Code: 0x80072afc (11004)
Windows Error Text: The requested name is valid, but no data of the requested type was found.
  Source File Name: sqlca\nlregca.cpp
Compiler Ti

Cluster Security Policy -- Configuration in SQL Server 2008 R2 (Side by Side with SQL Server 2000

  

Hi all

Please I have SQL Server 2000 running on Windows 2003 SP2 (A/P) Cluster,Now we are adding new SQL Server 2008R2 Instance to Cluster.

I want know "Database Engine Domain Group","SQL Server Agent Domain Group" section,can I select excisting SQL Server 2000 Engine Domain group or I required to Configure  some thing else.

and

How to find out "Database Engine Domain Group","SQL Server Agent Domain Group" of  excisting SQL Server 2000.

 

Thanks in Adavnce

 

 


SNIVAS

SQL server 2005 SP3 installation on windows server 2008 64 bit

  

Hi Guys, I was using SQL server 2008 64 bit with my application on windows server 2008 64 bit and all was working fine; then i decided to test SQL server 2005 SP3 64 bit to install on server 2008 64 bit, for this i first uninstalled SQL server 2008 64 bit and then downloaded the SQL server 2005 SP3 from the following address:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4

and after downloading this exe i started the installation and as soon the installation started i got the following display message that:

"this machine does not have the product that matches this installation package"

The link from where i have downloaded the SQL server 2005 SP3 64 bit file says that ti supports windows server 2008. I am using windows server 2008 Enterprise 64 bit having .NET framework 3.5SP1..

softwares required / installation steps for using SSRS 2008 along with SQL server 2005 as DataSource

  

Hi,

I want to use SSRS 2008 to develop reports, but SQL server 2005 should be used as datasource, so I assume that,

1) MS Visual Studio 2008 and SQL Server 2008 should be installed to get SSRS 2008 and BIDS

2) SQL server 2005 should be installed and in "Reporting Services Configuration Manager" the Database section should point to SQL server 2005

Please suggest whether the approach is correct or not, if not please give me the correct way to achieve it.

Thanks,

Avinash


call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Accessing SharePoint 2010 Data with Server-Side APIs

  
Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Server side validation of Fileupload control not working

  
 

 


I've tried this method in my code behind to try and validate that the Fileupload control has a file or not. I get the error message the the event "Server Validate" cannot be found. Can anyone tell why? Thanks.


Public Sub CustomValidator1_ServerValidate(ByVal source As Object, ByVal args As System.Web.UI.WebControls.ServerValidateEventArgs) Handles CustomValidator1.ServerValidate
       

' Get file name

        Dim uploadAvatar As FileUpload = DirectCast(AdvertisementForm.FindControl("uploadAvatar"), FileUpload)

        Dim UploadFileName As String = uploadAvatar.PostedFile.FileName

        If UploadFileName = "" Then
            ' There is no file selected
            args.IsValid = False
        Else
            Dim Extension As String = UploadFileName.Substring(UploadFileName.L

server side does not save data when using POST data to another URL using WebRequest

  

Hi,
 I am using a IIS 7.5 on Windows 7. I have a simple application that uses System.Net.WebRequest to POST data to another URL (in fact, the server side URL is on my local computer and it is hosted in IIS 7.5).

  1.  The problem is the server does not save data from client although on the client side codes when I debug and I see the OK message return from the code line

   response.StatusDescription; // this has value of "OK"
 
 
2. How can I debug the server code side where to receive the request from client side who posts the data ?
 


The following is the codes for client who posts data using System.Net.WebRequest, and codes for server side who received posted data to save to database.


Client side codes: // also run on my local computer

public string PostIntegrationXml(XmlDocument xmlSubmitDoc)

        {

           

    &nbs

Office Services: Merging Word Documents on the Server Side with SharePoint 2010

  

Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010


Cutting Edge: The Server Side of ASP.NET Pages

  

Where are the files generated by ASP.NET stored and how are they used to serve page requests? This month Cutting Edge explains.

Dino Esposito

MSDN Magazine January 2007


Basic Instincts: Server-Side Generation of Word 2007 Docs

  

This month, Office Open XML, which allows ASP.NET and SharePoint developers to read, write, and generate Word, Excel, and PowerPoint documents on the server without running an Office desktop application there.

Ted Pattison

MSDN Magazine November 2006


ASP.NET Pipeline: Use Threads and Build Asynchronous Handlers in Your Server-Side Web Code

  

Fortunately for developers, threading in ASP.NET is a lot easier than it was in ASP. In this article, the author takes a look at threading in the ASP.NET HTTP pipeline, and explains how threads are managed efficiently without the involvement of the developer. The article considers how the common language runtime threadpool is used by ASP.NET to service requests, looks at the pooling mechanisms used for handlers, modules, and applications, and covers both IIS 5.0 and IIS 6.0 and how they differ in their approach to request processing and thread allocation. Finally, how and when to use asynchronous handlers is discussed for developers who still need to use threads in their own applications.

Fritz Onion

MSDN Magazine June 2003


Categories: 
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