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
Tag: SQL Server
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
SQL Server2008 R2 Evaluation period expired!
We ran into the problem this morning - an error Window poped up saying the evaluation period has expired when I launched the SQL Server Management Studio. Don't know why this is happening, as we did use a licensed media to install. The product ID is embeded in the media and no need to manually … Continue reading SQL Server2008 R2 Evaluation period expired!
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