Posts

Showing posts from March, 2016

Moving SQL Azure to local SQL or Azure SQL to VM SQL

Image
There are many requirements like moving database between:

1. SQL Azure to local development SQL Server 2. SQL Azure to Virtual Machine SQL Server 3. Development SQL Server to Production SQL Server 4. Production SQL Server to Development SQL Server

Rename database data files and logical files in SQL Server

When I rename database using SQL Server Management Studio I always change its data files (mdf, ldf) name as well as logical file name of the resource. And this is very common need for SQL Server guy.

Popular posts from this blog