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


Top 5 Contributors of the Month
david stephan
Asad Ali
Fauzul Azmi
Post New Web Links

need help moving System Center SQL Databases to new SQL Server about30 databases to be moved...

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :Sql Server
 
We are running various System Center products, SCSM, SCVMM, SCCM, DPM, OPALIS. and a few other servers all using the same SQL server, which currently is a VM. We have configured and built a new Physical box that will replace this. In the past we have moved SQL databases by doing a full backup and then restoring the backup on the new server, then renaming the servers, both network name and internal sql name.  This has worked fine in the past. However I've never had to move 30 databases before, nor have I had to move reporting services. Is there a better method. a recomended method? 


View Complete Post


More Related Resource Links

Best practices on moving SharePoint databases physically, while keeping them on the same SQL server?

  
I'd need to move the SharePoint 2010 databases (preferably all of them) with as little hassle as possibly from one partition to another. I tried once, and ended up with a broken SharePoint and had to recover from backups. What's the best practices for moving the databases without breaking SharePoint completely in the process? I'm guessing I need to shut down the SharePoint server for this... That's not impossible if needed.

SharePoint 2010 Foundation - Standalone - SQL Server Express 2008 R2 - Moving databases to another d

  

Setting up a new install who will be using SharePoint Foundation 2010 in Standalone mode. They do not have SQL SERVER 2008 so need to utilize the Standalone option and the latest version of SQL Server 2008 Express R2. They are just getting started with SharePoint and it is unknown how much the technology will be embraced to afford to purchase SQL Server at this point. I wanted to get that explanation out of the way before everyone tells me the best practice of installing in Farm mode only! I realize the best practice but sometimes we have to roll with the punches because getting a client to begin using SharePoint on their current budget is better than never getting the chance to use it at all.

So SharePoint Foundation 2010 is installed with the default SQL Server 2008 R2 Express instance. Is there a procedure for moving the databases to a new drive? What is the default instance name that is created? I'm having a hard time locating that information in the documentation. I've done this before with WSS 3.0 without issue but wondered if there were any documents on moving the newest databases and what the default instance name is. Thank you in advance.

Rick


Moving the sharepoint databases to another server

  
I have integrate TFS 2010 and SP 2010 but each of these app dbs are on different SQL servers and in different geograhics locations. ie TFS DBs are in location A and SP 2010 DBs are in location B, connected via a WAN.  SP 2010 is running slow and I am assuming it is because of this configuration that could be a main cause of this.  So I would like to move the SP databases onto the same server as the TFS DB's is there and easy way to do this?

Getting server non system databases, getting database tables, getting table columns

  

I use next code to get server databases

string connectionString = "Data Source=DENIS\\SQLEXPRESS;Integrated Security=SSPI;";
DataTable tables = new DataTable("Tables");
using (SqlConnection connection =
    new SqlConnection(connectionString))
{
  SqlCommand command = connection.CreateCommand();
  command.CommandText = "sp_databases"; 
  command.CommandType = CommandType.StoredProcedure;
  connection.Open();
  tables.Load(command.ExecuteReader(CommandBehavior.CloseConnection));

}

this.dataGridView1.DataSource = tables;

I've got many databases :

- model ( i guess it is system )

- master ( i guess it is system )

- tempdb ( i guess it is system )

- db1 ( my table )

and etc.

How to determinate what table is system.

http://blog.sqlauthority.com/2007/06/26/sql-server-2005-list-all-tables-of-database/

SELECT *

FROM information_schema.Tables

So how to determinate what table is system or not.

Can I get tables of database

Cant move system databases of SQL Server 2008 (Clustered) running in Windows 2008 with Service SID e

  

Hi,

I was trying to move system databases of SQL Server 2008 on clustered emvironment running on Windows 2008.

I remember while doing the cluster installation somewhere it gave me a recomended option of using Service SID. I think that is the culprit here. Because if you see the "Security" of the DATA folder containing all the MDF and LDF (by default location) you will find a Group named "MSSQLSERVER" is having full access to that directory.

While moving the system databases you need that account (MSSQLSERVER) given access to the parent directory containing the MDF and the LDFs, But unfortunately you cannot add that account manually. Even I tried XCOPY to make sure that while copying the ACLs gets transferred properly to the destination, even that failed.

I think it does provide a solid Security but at the expense of Maintenance, which I cant agree.

Also I forgot to tell you that this Sevice SID option is available if you are using Windows Vista / Windows 2008 or above,

Does anyone has any experience of moving the system databases with Service SID enabled in a cluster environment.

As a testing just try to copy/xcopy/robocopy any folder having MSSQLSERVER group in the ACL and see what happens .. If you are lucky like me then you will get ACCESS DENIED error.

Have anyone faced the same error? I h

Linq with two databases (oracle and sql server)

  

Hey,
i have a problem to bring the data from the oracle (external database) and the sql server together (with similar data). The linq entities are linked to each other. The structure is like different countries with different cities and so on. To display these "non original linq objects" i need to put them into entities (linked to each other). Now i add some of them to my sql database. But for every entity i must check the connection to the other objects i don't want to add and delete them (otherwise linq will add all the connected objects, even those I don't want to add). If this goes wrong the whole input-method crashes. Is there any other possibility, except from checking every single entity and removing unwanted connections, to handle this procedure?
Thanks a lot, preg


Joining tables from 2 SQL Server CE databases

  
Is it possible to join 2 or more tables in different SQL Server CE databases? I am currently using VB.NET 2008 and SQL Server CE 3.5.

(SQL Server 2008) Exporting entire databases to SQL CREATE/INSERT statements

  
Hi All, I'm looking for a way to export SQL Server 2008 (Express or otherwise) databases to CREATE/INSERT statements.  I've seen a million threads (give or take) with instructions for creating large (often illegible) TSQL scripts for the task.  However, I'm hoping that this isn't the only way by which to do it.  I have need to regularly back up the data from existing MS SQL Server DBs (which are used by some of our standard apps) to various other MySQL and PostgreSQL databases (which are used by PHP and Rails web front ends).  I need to export them from MS SQL Server 2008 to a general format (i.e. INSERT statements) and perform regex edits on the file as necessary. FYI, I've written a few applications that connect to the various DBs over ODBC, etc. and transfer the data row by row.  You can image how painful this process is... I realize that there are many tools that do this.  However, most of them approach the issue from the standpoint of migration, and not that of regularly scheduled backups.  Also, this tool will need to eventually be distributed so having to purchase a license for the migration app for each person/group simply isn't feasible. Anyway, if you guys have a quality, straightforward solution to this issue, it would certainly be appreciated. Best.

Cannot rebuild system databases in 2008R2

  
I'm trying to rebuild system databases, but after installing 2008 R2, this no longer work. Here is what I do: I open a command prompt in the below folder: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2 Here, I execute: SETUP /ACTION=REBUILDDATABASE /INSTANCENAME=a /SQLSYSADMINACCOUNTS=TK\Tibor /SAPWD=Pa$$w0rd /Q I get below error in the console window: The following error occurred: Exception has been thrown by the target of an invocation. Error result: 1152035024 Result facility code: 1194 Result error code: 43216 Please review the summary.txt log for further details There is no trace of the rebuild in the summary.txt file. A folder *is* however created in the log directory for the rebuild (20100601_163136), and in here I have a file named Detail_ComponentUpdate.txt. In this file, I can find below errorr, which I believe is the root of the problem. Can anybody else perform rebuild? Any ideas or hints? 2010-06-01 16:32:04 Slp: Running Action: ExecuteInitWorkflow 2010-06-01 16:32:04 Slp: Workflow to execute: 'INITIALIZATION' 2010-06-01 16:32:04 Slp: Error: Action "Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction" threw an exception during execution. 2010-06-01 16:32:04 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Exception has been thrown by the target of an invocation. ---> System.

Moving Databases between Drives

  
I have Sharepoint WSSv3 running and configured as a farm, using SQL 2008 Express on the same server and wondered what steps i would need in order to move the database from the C:\ to the E:\ (on the same server). I have been told in a previous thread to detatch the db and move the files and reattach the db, but then someone replied Don't forget to change the default paths so the subsequents DBs are created on E:?? What Default Paths?? what i was going to do is: Stop all sharepoint and sql services detach the db move all databases onto the E:\ reattach the db restart the sharepoint and sql services Is this correct??

Run Reporting services 2005 with databases housed on SQL Server 2008?

  
Hi, I have a RS 2005 install in which the ReportServer and ReportServerTempDB databases reside on a different SQL Server 2005 server. I am planning to upgrade both to 2008 at some point but would like to do the SQL database engine first. So I would be running something like this: Server A: SQL 2005 Reporting Services Server B: SQL 2008 database engine - housing ReportServer and ReportServerTempDB Is this configuration supported? If I do this would I just need to run the DB's in 9.0 compatibility mode until we upgrade the RS server? Would it be better to upgrade the RS box first or both of them at the same time instead of doing the database engine first?

Run Reporting services 2005 with databases housed on SQL Server 2008?

  
Hi, I posted this in the RS forum as well but was thinking it would be better here. I'm not sure if I can move a post to  a different forum or not so sorry for the double post. I have a RS 2005 install in which the ReportServer and ReportServerTempDB databases reside on a different SQL Server 2005 server. I am planning to upgrade both to 2008 at some point but would like to do the SQL database engine first. So I would be running something like this: Server A: SQL 2005 Reporting Services Server B: SQL 2008 database engine - housing ReportServer and ReportServerTempDB Is this configuration supported? If I do this would I just need to run the DB's in 9.0 compatibility mode until we upgrade the RS server? Would it be better to upgrade the RS box first or both of them at the same time instead of doing the database engine first?

SQL Server Security > Logins vs. Databases > Security > Users

  
Why isn't all security needs done just in logins?  When migrating databases, the Logins are not brought over when restoring a backup.  It does not make sense.  Could it not be done all just in the Security > Logins area or why not?  That COULD be designed to track users and rights on various databases rather than a thing owned by each database....Thanks for your time.Gib

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

"NT AUTHORITY\SYSTEM" access - to which databases/actions and why?

  
Subquestion from the question Purpose of "NT AUTHORITY\SYSTEM" login in SQL Server 2005 discussing removal of NT AUTHORITY\System from SysAdmin group in MS SQL Server 2005. Is my SQL Server 2008 R2 "NT AUTHORITY\SYSTEM" login is mapped (right click on --> Properties --> User Mapping) to: user dbo for db AdvenureWorks user "NT AUTHORITY\SYSTEM" for databases - maser - msdb - ReportServer - ReportServerTempDB But no mapping exists for databases tempdb model any manually new created database AdvenureWorks2008 AdvenureWorks2008R2 AdvenureWorksDW AdvenureWorksDW2008 AdvenureWorks2008R2 AdvenureWorksLT AdvenureWorksLT2008 AdvenureWorksLT2008R2 Why such mapping was created for AdvenureWorks but not all other sample databases and newly created databases? Why does ReportServerTempDB requires mapping but not tempdb?

Error While Rebuilding system databases

  
Hi, I installed my SQL Server with a wrong collation. I tried to rebuild the instance and when i tried doing that I am getting a weird error as given below. ALso the installation is picking the edition as evaluation instead of enterprise, i tried executing the install file and it went through to install a enterprise edition. I am not sure why the installer is picking up the evaluation edition instead of enterprise as the option is set.  Exception summary: The following is an exception stack listing the exceptions in outermost to innermost order Inner exceptions are being indented Exception type: Microsoft.SqlServer.Setup.Chainer.Workflow.NoopWorkflowException     Message:          The state of your SQL Server installation was not changed after the setup execution. Please review the summary.txt logs for further details. SugeshKumar SQL Server MVP http://sugeshkr.blogspot.com

Cluster SQL 2005 SP3 (system databases)

  

Hello All !

I have a MSCS cluster Windows 2003 Ent SP2 R2 (2 nodes en Active / Passive) and I install SQL 2005 SP3. I need to install 2 MS SQL Server instances on this cluster.

I have volumes shared disks: - Q for Quorum, M for MSDTC, L for logs, S for Datas, T for TempDB, X for Indexes

I want to put system databases on Y.

I have a doubt:

I have 2 SQL instances (ISQL1 and ISQL2), do I need a separate volume for the system DBs (master, model, msdb, tempdb) per instance?

or  do I need one volume for all the system DB (Y) for the 2 instances?



Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2
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