chima
asked on
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.
Thanks
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.
Thanks
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.
ASKER
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
PS When making changes to the account, do use the SQL configuration manager instead of Services applet ...
ASKER
thanks