Question: I’ve received some ISO files with the contents of SQL Server Enterprise and need to open them and retrieve the contents. I don’t have a specific disk image tool. I’m on a Windows 2012 server . Are you able to offer any advice or assistance? Answer: Windows Server 2012 supports the facility to Mount an ISO file without installing any extra software. Previously you needed a disk image tool installed. Back in the good old days of SQL Server 2005 - the process required extraction first - read more on SQL server 2005 install with ISO images Now all... Read more →
Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
- How to find privilege changes with SQL Server Default Trace
- sys.dm_server_services - How to check if SQL Server service is running or not?
- Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
- Can we restore a database to an older version in SQL Server?
- How do I save all SQL Agent Jobs
- How to view SQL Server mount point space without access to server
- DBCC SHRINKFILE: page could not be moved because it is a work table page.
- SQL Agent Last Modified explanation
- Sql certificate chain was issued by an authority that is not trusted
April 06, 2017
April 05, 2017
Data Migration Assistant for SQL Server 2016 Upgrade
The Data Migration Assistant (DMA) has replaced the SQL Server Upgrade Wizard. The big difference is the Data Maigration Assistant also offers an option to Migrate the databases. It's a key step in documenting how to update SQL Server. The details from the DMA give database owners detailed information about any changes required The purpose of this post is to focus on Assessment only not on the Migration Aspect. The Assessment type of usage is very similar to the Upgrade Wizard. There is also a command line option for the Data Migration Assistant , but I'll discuss the command line... Read more →