• About
  • Contact
  • Resources
  • Speaking, Technical Community Involvement & Publications

– Microsoft technologies and what I do for fun –

Monthly Archives: April 2008

>Automating SQL Server 2005 Express Backups and Deletion of Older Backup Files

29 Tuesday Apr 2008

Posted by Edwin M Sarmiento in Uncategorized

≈ Leave a comment


>I’ve compiled a couple of my scripts – both TSQL and VBScript – to create a tip for MSSQLTips.com on automating backups and deletion of SQL Server 2005 Express databases to mimic that of creating a database maintenance plan. You can check out the article for more details. Feel free to post comments on the MSSQLTips.com forum site and hopefully, you’ll find the tip very useful. I’ll write a few more tips for them in the long run just for the fun of it.

Advertisements

>Multiple connections to a server or shared resource by the same user, using more than one user name, are not allowed

21 Monday Apr 2008

Posted by Edwin M Sarmiento in Uncategorized

≈ 3 Comments


>I got this error when I tried to access a remote share from one of our DR servers. Well, apparently, the DR server configuration was not designed properly which is probably the reason why I am getting this error. The production and DR server both have the same configuration (or course, they are on a different network segment which is why this is possible) and I only get to access one or the other using a separate VPN profile. I was trying to copy a database backup from the production server and moving it to the DR server. The resolution: just run a net use * /delete command. It may sound simple but it works and that’s what is more important. Having the same configuration (hostname and IP address, in my case) is causing my Windows XP workstation to get confused so a simple purge of the cache of my shared folder information. I would have to do this quite often as I need to connect to both servers on a regular basis

>Follow-up on Policy-based Management in SQL Server 2008 v1

15 Tuesday Apr 2008

Posted by Edwin M Sarmiento in Uncategorized

≈ Leave a comment


>I asked Dan Jones about getting the policies in SQL Server 2008 to be evaluated in SQL Server 2005 and SQL Server 2000. You can create policies in SQL Server 2008 instances and use those policies to evaluate and even implement them in SQL Server 2005 and SQL Server 2000 instances with a couple of things to consider. One, if you are targetting facets which only exist in SQL Server 2008, the policies won’t get evaluated on previous versions. An example of this is creating a policy which checks whether or not FILESTREAM option is enabled on a database. This of course won’t get evaluated on previous version instances. The same is true when you intend to run the policies on previous version. You cannot run those policies on schedule or on-demand unless you use a workaround using PowerShell to do that. I’ll work on a couple of samples where I’ll create a policy in SQL Server 2008 and evaluate previous version instances based on that policy.

Thinking of cloning your workstations and servers?Think NewSID.exe

07 Monday Apr 2008

Posted by Edwin M Sarmiento in Uncategorized

≈ 2 Comments


How many times have I mentioned in my blog posts that I am indeed a lazy guy? Probably a lot of times. That is practically because I always think of ways to make my work, especially those repetitive ones, as easy as possible. This case is one of them. I regularly work with virtualization, whether using Microsoft Virtual PC/Virtual Server or VMWare Server or Workstation for my tests or even for simulations. And whenever I need to work with a few servers and workstations, I simply create a copy of the virtual machine to eliminate the time and effort to install the operating system and applying the service packs if they need to be on each one of those images. Many organizations use disk image cloning software such as Norton Ghost or Acronis both for mass deployment of operating systems and for disaster recovery. But if you are to simply use these tools (or my method using virtualization) for cloning purposes, you are in for a surprise if you do not change the computer security identifier (SID) of the different images. To validate what I mean by this, create two cloned images and deploy them on a network. Then, try logging in using a domain account on either of the machines and you’ll get the error mentioned below

The name or security ID (SID) of the domain specified is inconsistent with the trust information for that domain

Fortunately, SysInternals have a tool called NewSID v4.10. This tool is a program that changes a computer’s SID. It is free and is a Win32 program, meaning that it can easily be run on systems that have been previously cloned. NewSID works on Windows NT 4, Windows 2000, Windows XP and Windows Server 2003. You can download the tool from Microsoft and run it on the cloned machine to change its SID. It is recommended though that you run this tool on a machine that is not a member of a domain. You can choose to randomly generate a SID, copy an SID from another computer or simply specify one (which is not really recommended). You can also choose to rename the machine to a different one (in my case, I still needed to run this tool eventhough I’ve already renamed the cloned image since they are both going to be a part of the same domain). A rebot would be required after a SID change has been applied. Download the tool and try it out for yourself

Twitter Updates

  • In today's age of artificial intelligence and automation, we humans need to provide value where machines cannot. Th… twitter.com/i/web/status/1… 2 days ago
  • @TheStephLocke @kpuls Nah, not a failure in my books. I've done worse 😃 2 days ago
  • Amazing day for my #SQLServer DBA's Guide to #Docker #Containers and #Kubernetes @DifinityConf 4 days ago
  • @erikdarlingdata Even In-and-Out is worse than Jollibee? So much for data reliable data 5 days ago
  • @MikeyBronowski It is. You'll love it if you want to get into the world of container technologies 5 days ago
Follow @EdwinMSarmiento

SQL Server 2012 with PowerShell v3 Cookbook

SQL Server MVP Deep Dives Vol 2

Grab a copy now: SQL Server MVP Deep Dives Volume 2

SQL Server MVP Deep Dives Vol 1

Categories

AlwaysOn Availability Groups High Availability PowerShell SharePoint SQL PASS SQLPASS SQL Server SQL Server "Denali" SQL Server 2005 SQL Server 2008 SQL Server 2012 SQL Server Administration SQL Server Disaster Recovery SQL Server learning TechEd Asia 2008 Uncategorized Windows Cluster Windows PowerShell Windows Server 2008 Windows Server 2008 Clustering

Archives

  • March 2015 (4)
  • February 2015 (1)
  • November 2014 (1)
  • September 2014 (1)
  • July 2014 (1)
  • January 2014 (1)
  • December 2013 (1)
  • October 2013 (3)
  • September 2013 (4)
  • August 2013 (3)
  • July 2013 (2)
  • June 2013 (1)
  • May 2013 (1)
  • April 2013 (2)
  • February 2013 (1)
  • January 2013 (2)
  • December 2012 (1)
  • November 2012 (2)
  • October 2012 (1)
  • September 2012 (1)
  • July 2012 (3)
  • June 2012 (1)
  • March 2012 (4)
  • January 2012 (1)
  • December 2011 (1)
  • November 2011 (3)
  • October 2011 (2)
  • September 2011 (1)
  • August 2011 (2)
  • July 2011 (2)
  • June 2011 (5)
  • May 2011 (1)
  • April 2011 (3)
  • March 2011 (3)
  • February 2011 (1)
  • January 2011 (1)
  • December 2010 (1)
  • November 2010 (4)
  • August 2010 (2)
  • May 2010 (2)
  • April 2010 (1)
  • March 2010 (2)
  • February 2010 (2)
  • January 2010 (1)
  • December 2009 (1)
  • November 2009 (3)
  • October 2009 (1)
  • September 2009 (3)
  • July 2009 (3)
  • June 2009 (3)
  • May 2009 (2)
  • April 2009 (6)
  • March 2009 (8)
  • February 2009 (8)
  • January 2009 (2)
  • November 2008 (2)
  • October 2008 (3)
  • September 2008 (2)
  • August 2008 (5)
  • July 2008 (12)
  • June 2008 (5)
  • May 2008 (4)
  • April 2008 (4)
  • March 2008 (7)
  • February 2008 (3)
  • January 2008 (5)
  • December 2007 (6)
  • November 2007 (6)
  • October 2007 (22)
  • September 2007 (5)
Advertisements

Create a free website or blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy