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

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

Moving Distribution DB and Replicated DBs to a new SAN

Posted By:      Posted Date: October 02, 2010    Points: 0   Category :Sql Server

I have Transactional Replication running between 2 DBs on the same server, Publisher,Subscriber and Distributor are on the same server. We are moving aal our DBs to a new and faster SAN, including the 2 I am replicating.

Which is the best way to move them without disrupting replication or having to take it down and recreate it ? How can I move the Distribution DB?


View Complete Post

More Related Resource Links

Cutting Edge: Moving DataGrid Rows Up and Down


Imagine opening your Inbox one morning and finding a message that reads "Dear Mr. DataGrid, I urgently need an ASP.NET DataGrid that lets my users move rows on the client. You're my last hope. Will you please help me?"

Dino Esposito

MSDN Magazine March 2005

Return of the Rich Client: Code Access Security and Distribution Features in .NET Enhance Client-Sid


Rich clients employ many of the features and conveniences of the operating system they run on, and the list of these features has been growing since the dawn of the PC. But as apps have migrated to the Web, the trend towards increasing client-side functionality has ground to a virtual halt. There are several reasons for this; chief among them are security and deployment problems. But that's all about to change. With the .NET Framework, you can participate in building the distributable rich client of the future. In this article, the author enumerates the pertinent features of .NET that will allow you to build safe, easily deployable controls. The features discussed include managed code, code access security, versioning control, Windows Forms classes, and isolation.

Jason Clark

MSDN Magazine June 2002

Do not see the table in Database after moving the project folder



I created a ASP.NET project under Visual Web Developer 2008. Under that project I had a Database (along with ASPNETDB.MDF) which has about 3/4 tables (I had SQL server 2008). Everything was working fine (like insert, delete, etc.). And I was able to view the tables in database explorer view.

Then I had to format my computer for some reason and I copied the whole project in a USB drive and then after formatting the computer I copied the folder and tried to open it in Visual Web Developer (now I have VWD 2010). I can see the both Database under App_Data folder (ASPNETDB.mdf and the DB I created). ASPNETDB has all the tables and data as expected. But I do not see the tables under the DB I created.

I also tried in one of my friends computer who has Visual Web Developer 2008. But same result.

I am just wondering if anyone can help me with retreiving the table. I have a bad feeling that I might needed to do something to backup the data (not sure though). But the tables should be still there ... isn't it ?

Any help will be appreciated. Thank you in advance.

Moving a website - URL aliasing question


Hi we are migrating a website from a proprietary system  to a new system built inSQL 2008.

The old  system has about 6,000 pieces of content with individual hard-coded aliases. How could we go about creating a match table to ensure these resolve with our new system (based on Intellgentsia URL rewriter)?

Any pointers would be helpful.

Problems moving an InfoPath form from a DEV system to QA environment


We developed an InfoPath form using a local DEV environment.  The site collection under which the form was developed was http://server1/.

We are now attempting to deploy this form to a TEST environment that uses a slightly different structure for the collection, namely http://server2/sites/sitecol1.

In both cases the site that contains the form is /fin (so we were using http://server1/fin in DEV and want to use http://server2/sites/sitecol1/fin in TEST). 

The form contains VBA code and so requires admin-based deployment via Central Administration, so to deploy to TEST we:

1. Publish the form against the TEST server using InfoPath Designer

2. Upload the form using Central Administration > Application Managment > Manage Form Templates

3. After upload, we activate the form for the site collection http://server2/sites/sitecol1/

4. The form is then associated with a Form Library

When we try to create an instance of the form within this library we get the following error when we click on New to create the form instance:

The following location is not accessible, because it is in a differ

WSS 3.0 - problem with moving the database


My company wants to move a database included with WSS 3.0 installation to a *separate* server.
We want to have the database completely separated, on a different computer, on SQL Server 2005 installation.

Unfortunately, I'm not sure If the sharepoint is configured as a "Web Front End" or  "Stand-alone".
All I know, everything currently is on the same computer, and we can connect to the live database using the following path: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

The question is, how can we move the database to SQL Server 2005, on very different server, leaving the application untouched?

Quick summary, we currently have:

--- Server A: (WSS 3.0) + [windows internal database / SSEE (not sure!)] + DOMAIN X

and we want t

Moving to Vs2010


hello all!,

I'm trying move a class library project to VS2010 and I got problems with one  reference to this project. For some reason the reference look fine in the solution explorer but in the Object Explorer I can't to see the referenced assembly :(. I tried rebuild the solution but nothing :(

The message what I got in the code is:

"Namespace or type specified in the Imports 'MyCompany.common.services.Utilities' doesn't contain any public member or cannot be found."

Any help! :(

Moving SharePoint 2007 from Domain to a Workgroup


For development purposes, we have SharePoint 2007 installed on a virtual server (Wind 2003) on a company desktop (Vista Business ed.).  The SharePoint is using Active Directory and company domain. For learning purposes, we want to copy the virtual machine on another Vista machine that is outside the domain and is not using AD:

Question 1 : How can we move the SharePoint from a domain to a Workgroup
Question 2: Is it possible to still be able to use emails (through local installation of Outlook) on the same computer that is not on the domain? If, yes, what are the possibilities (any articles on it? Etc.)?


Moving Datarow from datagridview to textboxes

Hi , I need to know how to copy a datarow from datagridview to subsequent textboxes.I have three textboxes and three fields in datagridview .

Transactional replication: Updates to one of my columns (sometimes) does not get replicated from the

hi, This is my scenario: I have a varchar(max) column on a table that is replicated to other servers. I have a stored procedure that does and update to this column and other columns on the table. This is done inside a transaction that also includes other updates. When I call the stored procedure, this one varchar(max) column's value is not replicated. When I just run the single update statement on its own, the value is replicated. Anyone know something about this? Thanks!    

Moving Membership tables to production; empty

Hi all: I'm currently moving my application from my testing environment, onto our live environment.  I've moved my database, including all membership tables over, and everyting is empty.  Again, this is what I wanted.  The test environment had far too much "crap" data, including fake user, so I wanted to just start from scratch on the production environment.  I don't know how to re-create the application or the first user though in these membership tables??  I'm sure this isn't an odd thing to do, but I havent' had any luck yet with finding an answer of how to do this.  Any help is greatly appreciated! Thanks, Terri-Lynn 

Moving sites to new 2007 environment

I have a SharePoint environment that is running Sharepoint Server 2007 Trial (oops) on Server 2003 that I want to migrate off of asap.  I have built up a whole new SP environment that is 64-bit and Windows Server 2008 R2 that currently has MOSS 2007 but was built with the intent to upgrade to SharePoint 2010.  The new environment already has all the web applications and site colletions set up with some existing sites that I need to keep.  I have a lot of junk sites on the first environment that I don't want to move, so would like to move only the necessary sites to the new 64-bit environment as opposed to moving the whole database. I tried to back up and attach the content database but ran across issues I believe because of different SQL versions and the 32-bit vs. 64-bit....but admit I don't know much about it and could have done something wrong. What is my best course of action?  I assume move over the necessary sites and then upgrade to 2010?  Or can I upgrade and then move sites without having to pay for a 3rd party tool?  If I move sites before upgrading, what is the best method? I have had some luck with stsadm.exe but only some are successful while others fail.  Thanks!

Moving a Copy of SQL Report Server 2005 and Upgrade to 2008

Hello, We have SQL 2005 Report Server in a Windows 2003 64 bit server box. We want to create a copy of this report server database somewhere in the domain, so that we can access it for a different purpose. My question is, will there be any complications with this? I'm thinking about the encryption key that's needed to access the database. If we are successful with this, we might also want to upgrade to SQL 2008. Thanks for your help,   Elizabeth K.

Making an Exchange Distribution List an Approver for a Workflow step

I have a client that has an Exchange Distribution List populate by a team of specific stakeholders. They want a workflow that includes the Distribution List as an approver so that everyone in that DL has to approve before it moves on to the executive steering committee. What are the proper steps to making an Exchange DL a approver to a workflow in MOSS?  silly rabbit, tricks are for kids!

Moving files from one document library to another problem.

Hi, I have a strange problem with trying to move a number of files progammatically from one document library to another. I have a workflow running in sharepoint, which throughout the progress of the workflow, updates a word document stored in a document library, titled "CR".  Within the CR library there may also be a folder title "CR X" where x is the number of the document.  This folder contains any files which have been attached to the CR document.  I.E, excel files, pictures etc. When the workflow completes, the document should be moved to another document library called "Archived" which has a folder named after the year, i.e 2010, which inside that, contains a folder called the name of the document.  All the attached documents should also be moved to this folder. So for example, a document structure could be parentweb\parentsite\CR\CR 2.doc parentweb\parentsite\CR\CR 2\image.jpg parentweb\parentsite\CR\CR 2\image2.jpg Should, when the workflow completes end up looking like: parentweb\parentsite\Archived\2010\CR 2\CR 2.doc parentweb\parentsite\Archived\2010\CR 2\image.jpg parentweb\parentsite\Archived\2010\CR 2\image2.jpg. I have got the first part working fine, where the document is moved to the archive directory.  But I cannot move all the attachment files.  The loop I have to get the files and move them will wo

Moving WSS 3.0 to a new server

Hi, The server that I have Sharepoint on is dying and I need to move it to a new machine. The new server has different hardware and a different hostname. Can anyone point me in the direction of a guide as to how to do this? What I've done so far is install Sharepoint on the new server and copied the databases over. I've changed the web application using the central admin so it points towards the copied content database. I'm was thinking that it could be an issue that the hostnames are different so I've also tried changing the host header of the site to the same one as the old server. There are no errors or anything just the sites from the old server aren't appearing on the new. Any help welcome, - Claire  
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