Restore MSSQL database using batch script


If you are looking for a tool which can restore the MS SQL DB backup from the production environment to the development environment, this script is just the one that you are after. In my example, the script does the following things: 1) Copy of the latest pro db backup to local. 2) Close all connections of … Continue reading Restore MSSQL database using batch script

Advertisements

SQL express dynamic port causes vCenter service fail to start


A friend called and asked me why his vCenter service failed to start after the server reboot. After spending some time in investigation, I finally found the root cause – he uses SQL express to host the DB. And the SQL server port changed to another after the server reboot, which led to the SSO … Continue reading SQL express dynamic port causes vCenter service fail to start

VSS Issues on Windows 2003 Servers


Using VSS backup against the SQL server that is on Windows 2003 servers looks to me is always problematic. Here are some good articles talking about how to troubleshoot. http://support.microsoft.com/kb/940032 http://sql-blogs.com/2012/01/17/troubleshooting-vss-writer-issues/ http://blogs.msdn.com/b/sqlserverfaq/archive/2009/04/28/informational-shedding-light-on-vss-vdi-backups-in-sql-server.aspx

SQL Server Virtualization Recommendations on Hyper-V


Nice article talking about the best practice of running SQL server on Hyper-V: http://mssqldude.wordpress.com/2011/11/02/sql-server-virtualization-recommendations-on-hyper-v/  Lock Pages in Memory. In fact, this is quickly becoming a STANDARD recommendation on all SQL Server boxes and VMs that are dedicated as database servers. Virtual SCSI-attached virtual disks for all data disks give the best performance for SQL Server. … Continue reading SQL Server Virtualization Recommendations on Hyper-V