Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frobozzcompany
Starting Member
1 Post |
 Posted - 2007-10-16 : 09:50:48
|
| Hi all,This looks like a great place for SQL Server support. I hope you don't mind a few n00b questions.I'm a sysop whose main experience is with Windows XP and SBS 2003. I'm also reasonably familiar with Access 97/2000, having programmed a few small databases. I've recently acquired a client who is running the premium version of SBS, which includes SQL Server 2005. This means I have to manage this thing. This *huge* thing. So my first question is: Where can I find information to get me started, first from a sysop perspective, and later from a Access programmer perspective. What is your experience?Then two current issues. One is that for some reason SQL Server 2005 is using about 2 gigabytes of memory out of the box. Is this normal? Second, I can't for the life of me find the backup system. I can see backups being made of the AdventureWorks database (at 3:00), but even after 2 hours of searching I can't change the schedule. I knew how to do this in SQL Server 2000, but this version is very different.I'd much rather figure these things out on my own, but this product is just too complicated to learn in a few days, and the memory usage issue is critical.I'd be much obliged for any help you can offer. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-16 : 10:27:36
|
| There is a Maintenance Wizard in SQL 2005. That will allow you to set up backups and other houskeeping easily.Select server. In Object Explorer you should see Server : Management : Maintenance plans. RightClick that and use NEW. Should be fairly follow-your-nose.Tara's procedures are excellent, but they may be a bit daunting for a n00bie.Kristen |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-16 : 11:16:36
|
| If you want to view existing BACKUP jobs go to SQLServer Agent , which is found on the Object Browser in SQL Server Management Studio , and look at the JobsJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
|
|
Beginner questions