Common questions posted on SQL Server setup & deployment Forum

1. Licensing questions: Call (8004269400), Monday through Friday, 6:00 AM to 6:00 PM PST to speak directly to Microsoft licensing specialist. http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx http://www.microsoft.com/sqlserver/en/us/get-sql-server/licensing.aspx http://www.microsoft.com/licensing/about-licensing/sql2012.aspx  2. Setup failure (install, upgrade, patch, un-install): Post to SQL Setup & Upgrade MSDN forum, please upload/share SQL Server setup logs, you can use file/storage service like Skydrive to share/upload SQL…

0

Recovering from SQL Server upgrade failure

  1. The scenario here we are trying to upgrade from SQL Server 2008 R2 to SQL Server 2012, so I turned off the machine (simulating power outage) while upgrade is in progress   . 2. When I try to run upgrade command again, I am blocked with below rule   3. Generating discovery report…

0

Enabling TDE(Transparent Data Encryption) on all user databases

     Below blog post provides TSQL script that encrypts all user databases, please note: This posting is provided “AS IS” with no warranties, and confers no rights.           References     http://msdn.microsoft.com/en-us/library/cc278098(v=sql.100).aspx#_Toc18938467     http://msdn.microsoft.com/en-us/library/bb934049.aspx                                  — 0-…

0

Installing SQL Server 2012 Developer edition using SQL Server 2012 Enterprise evaluation media.

DVD corruption is common problem that may happen when installing SQL Server 2012, one way to solve this problem is to download SQL server 2012 Enterprise evaluation http://www.microsoft.com/en-us/download/details.aspx?id=29066   Then in product key dialog enter PID for developer edition                                 …

1

Migrating SQL Server 2000 user databases to SQL server 2012

T-SQL scripts to migrate SQL server 2000 user databases to SQL server 2012    1.      Backup SQL 2000 user databases using below scripts: Please customize parts highlighted in yellow /******************************************************************************** *         Backup SQL server 2000 user databases ********************************************************************************/   use master; go   DECLARE UserDatabases_CTE_Cursor Cursor FOR   — Selecting user database names. select name…

3

Installing SQL Server 2012 with Cumulative Update 1 (CU1) using Product update feature

  1-let us assume that we have CU1 package located in “C:\SQL2012Updates”, SQL server 2012 is installed from E: drive.       2-The command to install SQL server and CU1 will be  setup.exe /Action=Install /UpdateSource=”C:\SQL2012Updates”.       3-Product Updates screen will display the KB number of the CU package to be installed.  …

2

SQL Server set compatibility level for all server databases

use master; go     DECLARE UserDatabases_CTE_Cursor Cursor FOR   — Selecting user database names. select name as DatabaseName from sys.sysdatabases where ([dbid] > 4) and ([name] not like ‘$’)   OPEN UserDatabases_CTE_Cursor DECLARE @dbName varchar(100); DECLARE @compatQuery varchar(500);     Fetch NEXT FROM UserDatabases_CTE_Cursor INTO @dbName While (@@FETCH_STATUS <> –1)   BEGIN — set…

4

Installing SQL Server 2012(Enterprise & Express), SQL Server 2008 R2 (Enterprise & Express) on Windows 8 Release Preview using command line and un-attended installation.

    Installing SQL Server 2012(Enterprise\Express), SQL Server 2008 R2 (Enterprise\Express) on Windows 8 Release Preview using command line and un-attended installation.   1-Downloaded Windows 8 Release Preview from http://windows.microsoft.com/en-US/windows-8/iso. 2-All installations were run using command line prompt in elevated mode (run as Administrator)   1.       SQL SERVER 2012 Enterprise: setup.exe /Action=Install /q /IAcceptSQLServerLicenseTerms /InstanceName=<InstanceName>/ROLE=AllFeatures_WithDefaults …

0

T-SQL script to backup all user databases with time stamped backup file.

use master; go     DECLARE UserDatabases_CTE_Cursor Cursor FOR   — Selecting user database names. select name as DatabaseName from sys.sysdatabases where ([dbid] > 4) and ([name] not like ‘$’)   OPEN UserDatabases_CTE_Cursor DECLARE @dbName varchar(100); DECLARE @backupPath varchar(100); DECLARE @backupQuery varchar(500);   — make sure that the below path exists set @backupPath = ‘c:\SQLBackupFolder\’…

23