Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 250
  • Last Modified:

SQL System Databases

Hello,
I managed to connect to my SQLEXPRESS database and in the process, it created the following folders; Databases, Security, Server Objects, Replication, and Managament.  I'll be seaching the MSDN web pages for answers, yet would like to ask you if you could point out how to best use these system information?
I read that SQL keeps track of the data usage, but I have not found that information yet.
SQLEXPRESS foldersThanks
0
chima
Asked:
chima
  • 3
  • 3
  • 2
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
Those sustem datatbases are used by sql server, you dont have to worry about them. You can hardly change anything on those. If you want toplay with sql server, you need to create your own database and play with that.
0
 
chimaAuthor Commented:
aneeshattingal, good comment, thanks.  And while you bring up the subject, allow me to ask; I tried installing the AdvantureWorks sample database and have not been able to get it to show up.  You may have seen my other questions posted.  Might you have any suggestions?

My problem might be that I trying to install it on Windows7 64 bit;
http://www.idevelopment.info/data/SQLServer/DBA_tips/Installation/INSTALL_10.shtml
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
you have to make sure that you installed the sql server first, if you go to cobtrolpanel ->services  you will be able to see the service named 'sql server' there.
Then download the proper version of Adventre Works and work on it
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
David ToddSenior DBACommented:
Hi,

For the time being, ignore the system databases other than changing model from full recovery model to simple recovery model, and making sure that they are backed up.

Grab adventure works and go to town on that.

HTH
  David
0
 
chimaAuthor Commented:
aneeshattingal, it is late for me here, but I'll check it tomorrow night.
Meanwhile this is what I see;
SQL Services
0
 
David ToddSenior DBACommented:
Hi,

You have a named instance of SQLExpress.

To support named instances the SQL Server Browser service is running.

The agent is disabled because there is no agent properly speaking with SQL Express - a limitation of this edition of SQL.

Of concern is that the SQL Server Reporting Services is on automatic startup but not running. But only if you were using SSRS. The full-text filter is running and on manual startup so that is okay.

To conclude, other than checking out why reporting services isn't running, you have SQL Express installed and running.

HTH
  David
0
 
David ToddSenior DBACommented:
PS When making changes to the account, do use the SQL configuration manager instead of Services applet ...
0
 
chimaAuthor Commented:
thanks
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now