If you just want to generate a .sql script you can do this by right-clicking the database in Object Explorer and choosing Tasks > Generate Scripts: Then you can select database and all objects, or you can select just the table you want: Then select a location, and be sure to go into Advanced before … Read more
This happens if, when you made the backup, you had multiple files listed in the backup destination textbox. Go back to your source server and create the backup again; this time, make sure there’s only one destination file listed. If you had more than one file listed as the backup destination, the backup is striped … Read more
According to Aaron Bertand: You need to verify that the SQL Server service is running. You can do this by going to Start > Control Panel > Administrative Tools > Services, and checking that the service SQL Server (SQLEXPRESS) is running. If not, start it. While you’re in the services applet, also make sure that … Read more
Scroll down on that page and you’ll see: Express with Tools (with LocalDB) Includes the database engine and SQL Server Management Studio Express) This package contains everything needed to install and configure SQL Server as a database server. Choose either LocalDB or Express depending on your needs above. That’s the SQLEXPRWT_x64_ENU.exe download…. (WT = with … Read more
Well, glad I asked. The solution I finally discovered was here: How do I configure SQL Server Express to allow remote tcp/ip connections on port 1433? Run SQL Server Configuration Manager. Go to SQL Server Network Configuration > Protocols for SQLEXPRESS. Make sure TCP/IP is enabled. So far, so good, and entirely expected. But then: … Read more