From the course: SQL Server 2022 Administration

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Create SQL Server databases

Create SQL Server databases - SQL Server Tutorial

From the course: SQL Server 2022 Administration

Start my 1-month free trial Buy for my team

Create SQL Server databases

“

Creating new databases on your SQL Server instances is a fairly straightforward process. You basically set up how big you want them to be, where the files go and set up all the options on the particular database. But there's a little more tweaking and there's a couple other little things that I just want to walk through so you can see how everything interacts. So to make a new database, you simply in Management Studio, and all of what I'm about to show you can also be done via script, but through Management Studio, I'm going to right click my databases folder here and say, new database. This brings up the new database dialog, and the first page is quite simple. You just give it a name, specify where the files are and specify the owner. So if I call this InsideOutDB and I can leave the owner as default, that's fine with me, you'll notice it took my database name and it put it down here as the logical file name for my data, and it also put it as the name underscore log for my log data…

Contents