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
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
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!
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
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
To solve the storage problem of large files in SQL server. Some smart guys developed the BLOB concept, it stands for Binary Large Object. From the following diagram, you can see that the large files are stored in the DB table when there is no BLOB provider applied. This definitely will decrease the database performance … Continue reading Understanding BLOB
I experienced couple times the VM migration stuck in middle of the process due to this and that reasons. After the failed migration, there is not much you can do in the SCVMM console, as the only choice you can do is to click ‘repair’ to try to fix it. But sometimes, the repair can … Continue reading SCVMM 2008 R2 VM Status Tricks