{"id":290,"date":"2022-03-23T10:06:44","date_gmt":"2022-03-23T09:06:44","guid":{"rendered":"https:\/\/prodinfo.es\/?p=290"},"modified":"2022-03-23T10:06:44","modified_gmt":"2022-03-23T09:06:44","slug":"instalar-sql-server-2019-en-windows-11","status":"publish","type":"post","link":"https:\/\/prodinfo.es\/?p=290","title":{"rendered":"Instalar SQL Server 2019 en Windows 11"},"content":{"rendered":"\n

El problema son los sectores, SQL necesita 4KB y el sistema operativo utiliza 16KB o 32KB.
Hay un art\u00edculo de Microsoft que explica esto:<\/p>\n\n\n\n

https:\/\/docs.microsoft.com\/es-es\/troubleshoot\/sql\/admin\/troubleshoot-os-4kb-disk-sector-size<\/a><\/p>\n\n\n\n

Lo que hay que hacer es iniciar SQL con DBCC TRACEON 1800.
En configuraci\u00f3n de SQL Manager a\u00f1adir el par\u00e1metro -T1800<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Probablemente de un error que no se encuentra la BBDD:<\/p>\n\n\n\n

d:\\dbs\\sh\\s19s\\0924_133725\\cmd\\2\\obj\\x64retail\\sql\\mkmastr\\databases\\mkmastr.proj<\/p>\n\n\n\n

Esto es porque no apunta correctamente la BBDD master.
Hay que copiar de otra instalaci\u00f3n de SQL SERVER las BBDD: master, model, MSDBData, temp<\/strong> en la carpeta de instalaci\u00f3n.<\/p>\n\n\n\n

Despu\u00e9s ejecutar los siguientes comandos:<\/p>\n\n\n\n

NET START MSSQL$SQLEXPRESS \/f \/T1800\n\u00f3\nC:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQLEXPRESS\\MSSQL\\Binn> .\\sqlservr.exe -sSQLEXPRESS \/f \/T1800<\/code><\/pre>\n\n\n\n
Luego ejecutar los siguientes comandos<\/p>\n\n\n\n
SQLCMD -S .\\SQLEXPRESS\n\n1>SELECT name, physical_name, state_desc FROM sys.master_files ORDER BY database_id;\n<\/code><\/pre>\n\n\n\n
Ahora observe esos nombres de archivo incorrectos; y ejecuta los siguientes comandos…<\/p>\n\n\n\n
Nota: debe cambiar la ubicaci\u00f3n del nombre del archivo…<\/p>\n\n\n\n
2>ALTER DATABASE model MODIFY FILE ( NAME = modeldev, FILENAME = 'C:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQLEXPRESS\\MSSQL\\DATA\\model.mdf');\n3>ALTER DATABASE model MODIFY FILE ( NAME = modellog, FILENAME = 'C:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQLEXPRESS\\MSSQL\\DATA\\modellog.ldf');\n\n4>ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBData, FILENAME = 'C:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQLEXPRESS\\MSSQL\\DATA\\MSDBData.mdf');\n5>ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBLog, FILENAME = 'C:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQLEXPRESS\\MSSQL\\DATA\\MSDBLog.ldf');\n\n6>ALTER DATABASE tempdb MODIFY FILE ( NAME = tempdev, FILENAME = 'C:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQLEXPRESS\\MSSQL\\DATA\\temp.mdf');\n7>ALTER DATABASE tempdb MODIFY FILE ( NAME = templog, FILENAME = 'C:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQLEXPRESS\\MSSQL\\DATA\\temp.ldf');\n\n8>GO\n\n9>EXIT<\/code><\/pre>\n\n\n\n
NET STOP MSSQL$SQLEXPRESS<\/p>\n","protected":false},"excerpt":{"rendered":"
El problema son los sectores, SQL necesita 4KB y el sistema operativo utiliza 16KB o 32KB.Hay un art\u00edculo de Microsoft que explica esto: https:\/\/docs.microsoft.com\/es-es\/troubleshoot\/sql\/admin\/troubleshoot-os-4kb-disk-sector-size Lo que hay que hacer es iniciar SQL con DBCC TRACEON 1800.En configuraci\u00f3n de SQL Manager a\u00f1adir el par\u00e1metro -T1800 Probablemente de un error que no se encuentra la BBDD: d:\\dbs\\sh\\s19s\\0924_133725\\cmd\\2\\obj\\x64retail\\sql\\mkmastr\\databases\\mkmastr.proj<\/p><\/div>\n
Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-290","post","type-post","status-publish","format-standard","hentry","category-sin-categoria"],"_links":{"self":[{"href":"https:\/\/prodinfo.es\/index.php?rest_route=\/wp\/v2\/posts\/290","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodinfo.es\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodinfo.es\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodinfo.es\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodinfo.es\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=290"}],"version-history":[{"count":2,"href":"https:\/\/prodinfo.es\/index.php?rest_route=\/wp\/v2\/posts\/290\/revisions"}],"predecessor-version":[{"id":293,"href":"https:\/\/prodinfo.es\/index.php?rest_route=\/wp\/v2\/posts\/290\/revisions\/293"}],"wp:attachment":[{"href":"https:\/\/prodinfo.es\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodinfo.es\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodinfo.es\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}