So, to make this happen through Enterprise Manager, do i just:

Right-Click on specific database > Properties > File Groups Tab

Then just type in a name?

Then do I just add a...

george sibbald (7/29/2008)

---

got to agree it is worth keeping at least two backups on disk, especially as if you have to recover a database its always possible it is required...

Only need one night because we have a backup system (Tivoli) that backs up everything on the server every night. In the backup plans for Tivoli, we save something like...

Not from what I have read. PAE just lets windows utilize all the memory. AWE has to be turned on in...

Michael Earl (7/25/2008)

---

That's a reasonable start. I usually put the OS and SQL Install on the same drive. Depending on the SQL logs (not the log files) you...

Michael Earl (7/21/2008)

---

SQL Servers will vary depending on the purpose of the database(s) on them. It is a good start to make sure the OS, Data Files, Log Files,...

Have you refreshed your list in...

That is what we did but we capped ours at 12 GB. It showed incredible gains in efficiency.

Edit: ours was only SQL 2000 that we did this on.

Can you believe it? I have another quick question 🙂

When I use that checkbox to go into subfolders, does it know to only delete old files from the databases mentioned...

Jeffrey Williams (7/23/2008)

---

Verify the version on your client system. I am betting that your client software has not been upgraded to the correct version.

Both your server and the client...

Jeffrey Williams (7/23/2008)

---

jason.stephens (7/23/2008)

---

GSquared (7/23/2008)

---

My usual practice is to break up maintenance plans a bit. I'll rebuild some indexes one night, other indexes the next night, etc., and schedule...

GSquared (7/23/2008)

---

My usual practice is to break up maintenance plans a bit. I'll rebuild some indexes one night, other indexes the next night, etc., and schedule that to repeat...

Ok. Still getting errors. Is it common to make one large maintenance plan for instances or do most people just make little maintenance plans for each action? Or do people...

think I might of found it. Can online reindexing only be done on enterprise editions? if so, why even have the option on standard?

Thank you both and I will have the other one off-line before I bring this new one on the network with the new name 🙂