SQL and friends

I woke up at 6am after a restful 8 hours of sleep. Read for a bit, installed SQL Express on my laptop, ate a bowl of Raisin Bran, met up with a friend for coffee, called another friend, then came home to start the exercises in my Exam Reference book. The first exercise went well - it only used tempdb. The second exercise used a database called WideWorldImporters. I assumed it was a sample database that one can download through some Microsoft site. Found it!

https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0

Yep. Downloaded WideWorldImporters-Full.bak and set to work restoring the backup to my machine. I'd done that at work plenty of times. Heck, I can just use the GUI if I'm feeling lazy. GUI it is!!!

The operating system returned the error '3(The system cannot find the path specified.)' while attempting 'CreateDirectoryW' on '\?\D:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\WideWorldImporters_2.$FSLOG'.

Yikes! But, sure, \?\ doesn't start any drives I know of on my computer, so I should double check what the options are for the paths for the data and the logs.  It's listing  E:\Log\WideWorldImporters.ldf as the path for the logs, but I don't have an E drive, so I change that and retry. 

The operating system returned the error '3(The system cannot find the path specified.)' while attempting 'RemoveContainer' on 'D:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\WideWorldImporters_2.'.

...What... what the heck? It can't find the path? That is the path. I only have two drives. One holds the application.The other holds the data and transaction logs (if I had more drives, I would split the data and logs into different drives, but no option here). I look further at the GUI to see if it's putting something in the incorrect path. I open up Windows Explorer to see what files I have in my DATA folder and notice that I don't actually have an mdf (data) file! How do I have an ndf (user data) and ldf (log) and no mdf file? I head back to SQL Server Management Studio and find that WideWorldImporters database is a thing but stuck in a restoring state. I just decide to get rid of it and start fresh. I attempt to delete the database.

Drop failed for Database 'WideWorldImporters'.  (Microsoft.SqlServer.Smo)
------------------------------

 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:9; actual 0:0). It occurred during a read of page (1:9) in database ID 5 at offset 0x00000000012000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\WideWorldImporters.mdf'.  Additional messages in the SQL Server error log or operating system error log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB).


Are you kidding me? I can't even drop it? Disappointingly, hours later now that I'm writing this, I've forgotten how I eventually dropped it. After it was gone, I did more searching. Google/StackOverflow/mssqltips seemed to agree it was necessary to move the file when you restore it. That could be a possibility - after all, I don't see my mdf file, and it's gotta be here in the bak file somewhere, right? I stumble upon this page: https://www.mssqltips.com/sqlservertip/4394/download-and-install-sql-server-2016-sample-databases-wideworldimporters-and-wideworldimportersdw/

And that has this code:

USE [master]
GO
RESTORE DATABASE [WideWorldImportersDW] FROM  DISK = N'R:\SQLbackups\WideWorldImportersDW-Full.bak' 
WITH  FILE = 1,  
MOVE N'WWI_Primary' TO N'F:\SQL_Data\WideWorldImportersDW.mdf',  
MOVE N'WWI_UserData' TO N'F:\SQL_Data\WideWorldImportersDW_UserData.ndf',  
MOVE N'WWI_Log' TO N'L:\SQL_Logs\SQL2016\WideWorldImportersDW.ldf', 
MOVE N'WWIDW_InMemory_Data_1' TO N'F:\SQL_Data\WideWorldImportersDW_InMemory_Data_1',  
NOUNLOAD,  
REPLACE,  
STATS = 5
GO


I replace the paths here to paths that reflect my data drive, and success!! I have a working database! Two hours after I start a 'simple 2 minute restore', I can move onto the second exercise in the book, on page 7. Whew!
































Comments











Post a Comment



















Popular posts from this blog









Halloween Party and my costume




















Image







This weekend, I attended an awesome Halloween party, and even dressed up as Hermoine Granger.      I admit, it was a bit fun to dress up as Hermoine Granger. I took a lot of thought for my costume. I started searching for costumes on August 26th, and found a costume site on September 13th:  https://www.moviescostume.com/harry-potter-gryffindor-uniform-hermione-granger-cosplay-costume-adults-ver.html   However, I didn't want to just drop over $100 on a costume I'll likely only wear once. What else can I do? Can I just build the costume from regular clothes? After all, Hermoine mostly wore a school uniform for the first few movies. Certainly I could do that. I set off to build my uniform.   I got the skirt  from Lands End. The socks , blazer , patch ,  tie  and wand  from Amazon. The shirt came from J Jill, but I bought that about ten years ago or so, and the shoes I purchased last year from Belk.   I referenced this guide  to learn how to tie a Full Windsor Knot, a tie style wit








Read more










Board games and near the end of the gym challenge





















Today was another success! Went to the gym after my two cups of coffee, warmed up the rest of the Picadillo for lunch, and finished a few chores. This evening, I was invited to a board game night with a few friends. We played Spinjas and Stuffed Fables.   The gym was my last arm/chest routine day until the 31st, where I'll do the full body routine and see where I gained. I'm certain I didn't lose weight - way too many cookies and candies around to snack on, but hopefully I'm stronger. I certainly feel stronger and better, and that is enough to keep going. I'm looking forward to getting a better diet in January by not having sugar for the month, and continuing to go the the gym - just not daily.   Stuffed Fables is a really cute game! We played Story 1 where a girl's blanket is stolen from a little girl's bed, and the Stuffed animals characters, Theadora, Stitch, Flops and Lumpy have to travel through the underworld to rescue the blanket and get back to bed b








Read more










Jose and Sons review





















 I went with one of my friends to Jose and Sons Mexican restaurant on Glenwood Avenue and Pleasant Valley Road. I picked this place as I'd hear a lot of good things about it, and we were there early before the place got busy.  We were not impressed. The server was slow to get us our drinks, and did not get us chips and salsa, bur I could see his other tables got chips and salsa - turns out it was from a runner. We got ours eventually, (not from the server) but the first five minutes of our meal, we just stared at a bowl of guac and our two waters. No matter, maybe he was new. Maybe the kitchen was frying a new batch of chips. Maybe the bartender was new. While waiting, we noticed that the place looked like it needed new paint. In our booth, the pink paint was chipping off the wall. I was confused, because I thought they just moved here from downtown. They didn't even give the place a new coat of paint before moving in? The chips were warm, not hot, and the salsa was very sweet.








Read more