All Questions

Filter by
Sorted by
Tagged with
0
votes
1answer
57 views

Moving Partitioning Files To Another Disk Drive In SQL Server

There is a production table which was partitioned by someone in our company. Some partitioning files was wrongly located to different disk drive. I have to move those files to the disk where they ...
0
votes
1answer
31 views

Does Data Migration Advisor migrate system databases?

I would like to know if Data Migration Assistant copies system databases (master, model, msdb) into the new server.
0
votes
0answers
37 views

Not able to migrate DTS package from SQL Server 2008 to 2012. Getting errored out

Requirement: We need to migrate SSIS/DTS package from SQL Server 2008 to another machine having SQL Server 2012 on it. Steps performed so far: 1. First I exported the package from Source server to ...
1
vote
0answers
207 views

SQL Server with peer-to-peer replication migration from on-prem to AWS EC2 instances

I need to move three on-prem servers with peer-to-peer replication to AWS. SQL Server version is 2012. The AWS SQL Server will be on EC2 instances as the SQL Server RDS doesn't support replication yet....
2
votes
1answer
522 views

SQL Server Migration using a DB Mirror (Rolling upgrade)

I'm planning to do SQL Server migration of SQL Server 2012 to a new hardware and a new version of SQL Server (2016). I'm trying to find the best solution with minimal downtime. I found some ...
2
votes
1answer
371 views

Migrating Production SQL Servers (Availability Group) from one data center to another - questions

We have two SQL servers combined into Availability Group in data center 1 (dc1): dc1 server 1: SQL Server 2012 SP3 on Windows Server 2016 dc1 server 2: SQL Server 2012 SP3 on Windows Server 2012 R2 ...
1
vote
0answers
49 views

Migration to version 2016 from versions 2000, 2005, 2008, and 2012 [duplicate]

I just accepted a position that has multiple versions of SQL Server, from what I was told during my interview, it ranges from versions 2000 - 2012, the main goal is to centralized these databases to ...
1
vote
1answer
372 views

Copying large amounts of data to another target tables

I'm migrating large amounts of data +40m of rows to a new version of the tables, my question would be more like, what could be the best way to improve the performance in terms of logging and execution ...
0
votes
1answer
25 views

In-place up-gradation of SQL server on Azure with pre-image installed.

We have migrated our SQL server 2012 infrastructure from on-premise to Azure cloud recently where in all the production VM's are build with pre-images of SQL 2012 enterprise edition. So,here is the ...
0
votes
1answer
81 views

SQL sevrer DB migration plan [closed]

We are planning on migrating our existing SQL 2012 servers from current windows servers to new windows servers. Only difference is we are migrating this current instance which is standalone to ...
2
votes
1answer
394 views

Cannot re-attach SqlExpress database to the same database server after detaching?

This seems a bit strange. I migrated a database in a test environment from one server (SqlExpress) to another (full SqlServer). I did that by detaching the database from the first server, copying over ...
5
votes
2answers
167 views

How to definitively clear away database before restoring from new version of backup file

We are a team of mathematicians (i.e., no DBA experience). We are migrating from an old server box (SQL Server 2012) to a new server box (SQL Server 2017). For each database on the old server, we ...
2
votes
2answers
628 views

Availability Group of SQL Servers 2012, 2012 and 2016 possible?

We have two SQL servers combined into Availability Group in primary data center (dc1): dc1 server 1: SQL Server 2012 SP3 on Windows 2016 dc1 server 2: SQL Server 2012 SP3 on Windows 2012 R2 We are ...
0
votes
1answer
2k views

Upgrade/Migration from SQL Server 2008 R2 to SQL Server 2016

I have a client that is having plans to upgrade/migrate the SQL Server instances from 2008 R2 to 2012. I have provided the details as below. The environments are all Virtual running OS version Windows ...
1
vote
0answers
48 views

Migration of SQL Server Database

We have a situation here our application is working on SQL server on a cluster environment. Now we wish to migrate the database to a standalone environment, we have approx 2850 databases 1.6 TB in ...
-3
votes
3answers
253 views

How to administer large databases? [closed]

This is my situation right now: I'm working with SQL Server 2012, and I have 2 databases, one is 3.5 GB and the other one is 7.6 GB, and the company I work with is going to migrate the server to a new ...
0
votes
1answer
1k views

Data Migration and altering tables in one SSDT deployment script

I'm using SSDT and MS SQL Server 2012. And I need to handle next cases in one deployment script: --1 CREATE TABLE Table1 (Col1 INT) --2 INSERT INTO Table1(Col1) SELECT SomeCol FROM SomeTable --3 ...
5
votes
1answer
1k views

OLE DB error 0x80004005 using Copy Database Wizard

Background: freshly installed SQL Server 2012 SP3 on Windows Server 2012R2. Problem: When I use the Copy Database Wizard to copy a database from server2 to server2 I receive: While trying to find ...
2
votes
0answers
61 views

Migrating a Replicated Database from one SQLServer 2012 instance to another

We are working on a migration plan from old hardware to new hardware, these are SQL 2012 servers. A couple of the databases heavily use transaction replication so I'm trying to avoid recreating and re-...
4
votes
2answers
398 views

Capacity planning for SQL Server consolidation

My company has a small SQL environment for LANDesk and they want to migrate all the servers to a single SQL cluster per region. What I want to know is, how do I determine the capacity for such a ...
1
vote
1answer
260 views

SQL Server MDF still has old values after update

Let me start off saying I am not a DBA. My company is in the process of moving our SQL Server 2012 databases (recovery model of full) from one network to another. Due to security requirements, we ...
8
votes
2answers
24k views

Restore a SQL Server 2012 backup file in SQL Server 2016/2014

I have SQL Server 2012 backup files and want to restore these to SQL Server 2016/2014. Will it work? I need to find this out before I uninstall SQL Server 2012.
1
vote
1answer
684 views

How to move SSAS tabular instance databases?

We have a SQL Server 2012 SSAS tabular instance in our environment that is sitting in domain1. We need to move these SSAS databases in a different SQL server 2012 that is on domain2 which has no trust ...
2
votes
1answer
3k views

how to change the file directory of your log and data files and what are the effects

I have inherited a SQL server 2012 instance where the file directories of the log and data files are on the same folder on the same drive(all are in the C:\ drive). My task that I will be doing is ...
3
votes
1answer
291 views

How to migrate windows login in from one sql server to another sql server on another domain

We have a SQL server that is located in domain 1(DMN1). We are migrating databases in domain 1 to our new SQL Server in domain 2(DMN2).Corporate states that there will be no trust established between ...
0
votes
1answer
93 views

Migrate Database

I'm trying to migrate my database to another server, an older version. Currently my database is on SQL Server 2014, but I need to add migrate it to SQL Server 2012 because that's the one my server has....
2
votes
1answer
104 views

SQL Server 2005 still running after in place upgrade to sql 2012

We upgraded a default instance from SQL Server 2005 to 2012 today. But Components of SQL Server 2005 are still on the server. These includes the MSQL1. folder (it has all the data and log files), Mgmt ...
3
votes
0answers
549 views

Move SQL Server cluster from one location to other

I am looking for ideas on how to move SQL Server 2012(standard) two node cluster installed on Windows server 2012 standard to other location which is far away from current location. The two locations ...
0
votes
2answers
87 views

Source of network_name for distributor

So, I have a really weird case. Was doing a migration from sql server 2005 to 2012. Built the server, and at the last minute we found that the server was called abc/xyz. We just wanted abc, so the DBA ...
3
votes
1answer
126 views

Is replication a suitable method to move a SQL Server database to new hardware?

I need to move a live database with about 100 GB of data to a new machine. As I understand the easiest way to do that would be to take it offline, move the files and bring it back online. But: The ...
2
votes
2answers
96 views

Moving database from one server to another

I have a virtual machine running SQL Server 2012 in Azure and have also generated a script of my database to be run on the SQLSERVER2012 VM on Azure, however I am getting an error "C:\Program ...
1
vote
0answers
227 views

Migrating SQL 2012 Analysis Services to another server

We have a SQL Server 2012 installation that was built on...let's say a compromised Windows installation. It's had so many installs/uninstalls done on it that nothing runs consistently, and we're ...
2
votes
1answer
1k views

Converting old SQL Server outer join syntax

I'm a Power Builder (PB) developer. I've migrated PB from 10 .5 to 12.5, and now I need to migrate the stored procedures from SQL Server 2005 to 2012 as well. I get a invalid expression error when I ...
1
vote
2answers
457 views

SQL Azure Migration Wizard - Duplicate Primary Key

Just did a test at migrating a 120gb database onto RDS using SQL Azure Migration Wizard Because we can't afford any downtime for "just" a test we ran the tool on the live database (meaning data was ...
1
vote
1answer
3k views

How to migrate SSAS and SSRS from SQL Server 2008R2 to SQL Server 2012?

We are upgrading our SQL Server 2008R2 to 2012 and separate the SQL Server engine from SSAS and SSRS. We want put on Server 1 the engine and on Server 2 SSAS and SSRS. I did the side-by-side ...
0
votes
1answer
610 views

Do I need to rebuild indexes when upgrading a DB from 2008 to 2012?

I can't find anything on BOL that indicates I need to rebuild indexes or statistics after the migration and compatibility level upgrade of a database. But I have read a few articles/answers around the ...
7
votes
1answer
3k views

Move live SQL Server database to a new server

I have a production server running SQL Server 2008 Web Edition, and it has to keep running 24x7 with almost no down time, and it's the time for us to move to a more advanced server hardware, also it's ...
11
votes
6answers
19k views

Migrate from SQL Server 2000 to 2012 without a 2005 or 2008 instance

I have come across three old databases sitting on SQL Server 2000 which I need to move to 2012. I believe the standard approach is to restore into a 2005 or 2008 instance, update, re-export and ...
6
votes
1answer
550 views

Migrating VLDB to AlwaysON AG

I have been using AlwaysON AG for a long time now and currently have about 10TB of data across 120 databases and 3 AG groups for any application that is on SQL 2012 with great success. Each AG group ...
3
votes
1answer
180 views

Migrating SQL Server 2000 to 2012, getting old versions of Views (edit: offender SQL Server 2008 R2)

I'm migrating an ancient SQL Server 2000 database to 2012 (with a quick pass through 2008 R2 since 2012 is not compatible with 2000). The DB contains hundreds of views and stored procedures, and in my ...
0
votes
1answer
230 views

migrating legacy databases from SQL Server 2000 via SQL Server 2008 to SQL Server 2012: users and logins

I have some legacy SQL Server 2000 databases to migrate to SQL Server 2012. In my dry run, I have done this: I created empty databases of the same names in SQL Server 2008. Then I backed up the SQL ...
2
votes
0answers
85 views

SQL Server migration from 2005/2008 to 2012 [duplicate]

We need to upgrade two SQL Servers for our projects to SQL Server 2012. Since we’re not db-admins or familiar with such migrations, I wanted to ask you if you could tell me what we have to be aware of ...
2
votes
3answers
2k views

Looking for a utility to move data between databases (prod to dev) SQL Server 2012 [closed]

I am looking for an easy way to copy table data from a production SQL Server 2012 machine to a development machine (same version, level). We currently just do an export from within SSMS, but we have a ...
3
votes
1answer
634 views

Migrate Management Data Warehouse to a New Instance

Is there a defined procedure to follow for moving a SQL Server 2012 Management Data Warehouse to a new server\instance? We intend to setup MDW on a test SQL Server instance first, but will then want ...
0
votes
0answers
36 views

Post Database upgrade on new instance [duplicate]

I reviewed the SQL Server 2012 technical upgrade guide and also googled for more recommendations. I am migrating a SQL Server 2008 R2 instance to SQL Server 2012 on a separate machine. Here is what ...
2
votes
2answers
647 views

Scheduling duplication of two tables across instances

In my SQL Server 2012 database I have two tables: [tbl_Customers] - about 30 rows [tbl_Users] - about 10,000 rows I need to schedule the two tables above to be copied to a new instance, say every 12 ...
1
vote
1answer
4k views

Migrating Oracle packages to SqlServer

I'm moving database from Oracle to SQLServer (2012 if that matters). The process of migrating tables/views is more or less straightforward and automated. Triggers are also not an issue since I don't ...
1
vote
1answer
2k views

Alternative tools to export Oracle database to SQL Server? [closed]

I've got an Oracle database that I need to export (schema and data) to SQL Server. I am trying the Microsoft SQL Server Migration Assistant for Oracle, but it is horribly slow, grossly inefficient ...
4
votes
3answers
344 views

Easiest Way to Move 100 Databases

I need to move about 150 databases from one server to another server. SQL Server 2008 Web Edition SQL Server 2012 Preview (in a different datacenter - East Coast Azure) I was planning on moving them ...
78
votes
5answers
25k views

Are SQL Server in-place upgrades as ill advised as they used to be?

I have been working with SQL server on and off since SQL Server 6.5, the old advice that still rings in my head was never to do an in-place upgrade. I'm currently upgrading my 2008 R2 DEV and TEST ...