Upsizing from 2008 to 2019?

%3CLINGO-SUB%20id%3D%22lingo-sub-1086042%22%20slang%3D%22en-US%22%3EUpsizing%20from%202008%20to%202019%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1086042%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20many%20databases%20in%202008.%20%26nbsp%3B%20Can%20I%20backup%20and%20restore%20them%20into%202019%3F%26nbsp%3B%20I%20searched%20MS%20and%20found%20I%20could%20to%202017%20but%20no%20reference%20to%202019.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1086955%22%20slang%3D%22en-US%22%3ERe%3A%20Upsizing%20from%202008%20to%202019%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1086955%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F504288%22%20target%3D%22_blank%22%3E%40nmah01%3C%2FA%3E%26nbsp%3B--%20Yes%2C%20SQL2008%20to%20SQL2019%20backup%20and%20restore%20will%20work.%26nbsp%3B%20See%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Finstall-windows%2Fsupported-version-and-edition-upgrades-version-15%3Fview%3Dsql-server-ver15%23migrate-to-sql-server-2019%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ethis%20doc%3C%2FA%3E%20for%20specific%20supported%20upgraded%20paths.%26nbsp%3B%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have many databases in 2008.   Can I backup and restore them into 2019?  I searched MS and found I could to 2017 but no reference to 2019.

1 Reply

Hi @nmah01 -- Yes, SQL2008 to SQL2019 backup and restore will work.  See this doc for specific supported upgraded paths.  Thanks.