SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,984 questions
Microsoft Applied Skill 4 - Failure to create Databases 1-4
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 92%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jacob Shuster
0
Reputation points
While attempting the "Migrate SQL Server Workloads to Azure SQL Database" it failed to create Databases: DB1, DB2, DB3, and DB4. While DB5 was a partial. Has anyone else had this happen to them? What steps have you taken to resolve this issue?
I was looking for the creation scripts for the Databases, but had no luck locating them. Also, a review of the SQL Server Logs wasn't much help either as it only showed DB5 had restarted/restored from an earlier timestamp.
{count} votes
-
Erland Sommarskog 112.7K Reputation points MVP2024-07-14T09:53:37.6333333+00:00 Are you talking about https://learn.microsoft.com/en-us/training/paths/migrate-sql-workloads-azure/?
Since not everyone here might have done that module, maybe you can add some more information. These databases you talk about, are they created in on-prem SQL Server or are they Azure SQL Databases?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT 15,421 Reputation points2024-07-16T04:53:08.3966667+00:00 Hi Jacob Shuster •,
We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Thanks
-
Jacob Shuster 0 Reputation points
2024-07-24T20:43:11.4566667+00:00 Yes I am talking about that Module. They are supposed to be created at the time of Assessment start. However, in this instance, they did not. And was left with DB5. Essentially couldn't get any further in the module since you have to perform migrations of DB 1, 2, and 3. If there is a location for the creation scripts, then if that happens again I can run those instead of being a sitting duck.
-
Jacob Shuster 0 Reputation points
2024-07-24T20:45:16.85+00:00 I have not found a solution. I am sorry for the delay in response, the notification emails went to my spam.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 86%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
AmaranS 6,845 Reputation points Microsoft Vendor2024-07-25T10:46:41.32+00:00 Hi Jacob Shuster,
We're delighted to hear that your issue has been resolved. If you encounter any further challenges, please don't hesitate to get in touch with us, and we'll be more than happy to provide additional assistance.
Thank you.
Sign in to comment
Sign in to answer