New answers tagged sql-server-express
SQL Express has many disadvantages. If you've already paid for a real license you should use it. You don't have to consolidate everything in one instance, but I prefer not using Express... See http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx Max Compute Capacity Max memory utilized Max Database size AND No SQL Agent!
You can place your database files anywhere you want, you just have to specify these locations within SQL Server itself. There are two ways to relocate those files. Create in a new location When you create a database or add a file to the database, you can specify the new location and the file will be created there. For example, if I wanted to add a new ...
When sp_spaceused shows the database_size of about 25 GB in your first result set, that includes the data file/indexes, and the transaction log. Only the actual data and indexes count towards the SQL Server Express limits, so you have about 3.3 GB of data (as in your second result set) and the remaining 22 GB will be the transaction log. If you run ...
Top 50 recent answers are included