{"id":23,"date":"2007-02-28T15:14:22","date_gmt":"2007-02-28T15:14:22","guid":{"rendered":"http:\/\/www.myfatblog.co.uk\/?p=23"},"modified":"2007-02-28T22:06:34","modified_gmt":"2007-02-28T22:06:34","slug":"sql-2005-std-installation","status":"publish","type":"post","link":"http:\/\/www.myfatblog.co.uk\/index.php\/2007\/02\/sql-2005-std-installation\/","title":{"rendered":"SQL 2005 Std Installation"},"content":{"rendered":"

10 hours down the road and we now have a SQL 2005 installation. I’m not sure if I missed something during the install (and I did it twice after the tempDB issues (see below)) but I couldn’t find where to set the default Database and Logfile locations during install. (Should I have used the command line perhaps?)<\/p>\n

Anyway, after install, I then proceeded to follow the Microsoft KB article on moving the Master, Model, MSDB and TempDB databases. And here is the important hint, make sure you read a KB article all the way through before beginning to implement it. I didn’t and happily sailed through the article detaching and reattaching the databases right up until the TempDB which happily detaches, but won’t re-attach. And then your SQL install is quite frankly screwed. All that is required is restoring the MasterDB and you’re well away. I however have only just installed this server and thus don’t have a backup yet!!<\/p>\n

Back to the second install!<\/p>\n

This time the move went smoothly and I now have the following configuration.<\/p>\n

C: and D: on a pair of 36Gb drives housing OS and SQL binaries plus page file.
\nF: on 3 * 72Gb drives in a Raid 5 housing the Database files.
\nG: on 2 * 72Gb drives in a Raid 1+0 housing the Log files.<\/p>\n

For more information on moving the database and logfiles see:-<\/p>\n

How to move SQL Server databases to a new location by using detach and attache functions<\/a><\/p>\n

The next step today was the configuration of a Maintenance plan, but this wasn’t exactly free of problems as I hit the “GUID should be 32 characters with 4 dashes” error which is apparently a known issue. I’m loading SP2 now and we’ll see if they did managed to fix it in time!<\/p>\n

#EDIT# Turns out they did fix it in time!<\/p>\n","protected":false},"excerpt":{"rendered":"

10 hours down the road and we now have a SQL 2005 installation. I’m not sure if I missed something during the install (and I did it twice after the tempDB issues (see below)) but I couldn’t find where to set the default Database and Logfile locations during install. (Should I have used the command … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"yoast_head":"\nSQL 2005 Std Installation - Blog of an overweight SharePoint addict<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.myfatblog.co.uk\/index.php\/2007\/02\/sql-2005-std-installation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL 2005 Std Installation - Blog of an overweight SharePoint addict\" \/>\n<meta property=\"og:description\" content=\"10 hours down the road and we now have a SQL 2005 installation. I’m not sure if I missed something during the install (and I did it twice after the tempDB issues (see below)) but I couldn’t find where to set the default Database and Logfile locations during install. (Should I have used the command … Continue reading\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.myfatblog.co.uk\/index.php\/2007\/02\/sql-2005-std-installation\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog of an overweight SharePoint addict\" \/>\n<meta property=\"article:published_time\" content=\"2007-02-28T15:14:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2007-02-28T22:06:34+00:00\" \/>\n<meta name=\"author\" content=\"Cimares\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cimares\" \/>\n<meta name=\"twitter:site\" content=\"@cimares\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Cimares\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.myfatblog.co.uk\/index.php\/2007\/02\/sql-2005-std-installation\/\",\"url\":\"http:\/\/www.myfatblog.co.uk\/index.php\/2007\/02\/sql-2005-std-installation\/\",\"name\":\"SQL 2005 Std Installation - Blog of an overweight SharePoint addict\",\"isPartOf\":{\"@id\":\"http:\/\/www.myfatblog.co.uk\/#website\"},\"datePublished\":\"2007-02-28T15:14:22+00:00\",\"dateModified\":\"2007-02-28T22:06:34+00:00\",\"author\":{\"@id\":\"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/55ae8f6885bb5b8390dad001f3da83c6\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.myfatblog.co.uk\/index.php\/2007\/02\/sql-2005-std-installation\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.myfatblog.co.uk\/#website\",\"url\":\"http:\/\/www.myfatblog.co.uk\/\",\"name\":\"Blog of an overweight SharePoint addict\",\"description\":\"The rantings of a (not so) food obsessed IT consultant!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/www.myfatblog.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/55ae8f6885bb5b8390dad001f3da83c6\",\"name\":\"Cimares\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/About_D057\/TopOfTheWorld.jpg\",\"contentUrl\":\"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/About_D057\/TopOfTheWorld.jpg\",\"caption\":\"Cimares\"},\"sameAs\":[\"http:\/\/www.myfatblog.co.uk\"],\"url\":\"http:\/\/www.myfatblog.co.uk\/index.php\/author\/reginald\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL 2005 Std Installation - Blog of an overweight SharePoint addict","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.myfatblog.co.uk\/index.php\/2007\/02\/sql-2005-std-installation\/","og_locale":"en_US","og_type":"article","og_title":"SQL 2005 Std Installation - Blog of an overweight SharePoint addict","og_description":"10 hours down the road and we now have a SQL 2005 installation. I’m not sure if I missed something during the install (and I did it twice after the tempDB issues (see below)) but I couldn’t find where to set the default Database and Logfile locations during install. (Should I have used the command … Continue reading","og_url":"http:\/\/www.myfatblog.co.uk\/index.php\/2007\/02\/sql-2005-std-installation\/","og_site_name":"Blog of an overweight SharePoint addict","article_published_time":"2007-02-28T15:14:22+00:00","article_modified_time":"2007-02-28T22:06:34+00:00","author":"Cimares","twitter_card":"summary_large_image","twitter_creator":"@cimares","twitter_site":"@cimares","twitter_misc":{"Written by":"Cimares","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/www.myfatblog.co.uk\/index.php\/2007\/02\/sql-2005-std-installation\/","url":"http:\/\/www.myfatblog.co.uk\/index.php\/2007\/02\/sql-2005-std-installation\/","name":"SQL 2005 Std Installation - Blog of an overweight SharePoint addict","isPartOf":{"@id":"http:\/\/www.myfatblog.co.uk\/#website"},"datePublished":"2007-02-28T15:14:22+00:00","dateModified":"2007-02-28T22:06:34+00:00","author":{"@id":"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/55ae8f6885bb5b8390dad001f3da83c6"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.myfatblog.co.uk\/index.php\/2007\/02\/sql-2005-std-installation\/"]}]},{"@type":"WebSite","@id":"http:\/\/www.myfatblog.co.uk\/#website","url":"http:\/\/www.myfatblog.co.uk\/","name":"Blog of an overweight SharePoint addict","description":"The rantings of a (not so) food obsessed IT consultant!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.myfatblog.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/55ae8f6885bb5b8390dad001f3da83c6","name":"Cimares","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.myfatblog.co.uk\/#\/schema\/person\/image\/","url":"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/About_D057\/TopOfTheWorld.jpg","contentUrl":"http:\/\/www.myfatblog.co.uk\/images\/BlogImages\/About_D057\/TopOfTheWorld.jpg","caption":"Cimares"},"sameAs":["http:\/\/www.myfatblog.co.uk"],"url":"http:\/\/www.myfatblog.co.uk\/index.php\/author\/reginald\/"}]}},"_links":{"self":[{"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/23"}],"collection":[{"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=23"}],"version-history":[{"count":0,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/23\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=23"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/categories?post=23"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.myfatblog.co.uk\/index.php\/wp-json\/wp\/v2\/tags?post=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}