Started 1 week ago (2009-12-21 07:21:00)
by AndrewMurphy
>
For a response to an original activity that is 4+ years old, this advice is somewhat out of date. Other than pure product/service advertising....which comes very close to spam
Started 1 week, 6 days ago (2009-12-15 14:57:00)
by russell
>
Should not be rebooting so often. The long reboot time is for the databases to recover after you shut it down. It's not a hardware issue. Check to make sure nothing is taking exclusive use of the database every night...perhaps a job that sets it to
single user mode, or a nightly DBCC Checkdb. Make sure domain controller isn't rebooting as well.
Started 2 weeks, 1 day ago (2009-12-13 23:44:00)
by tkizer
>
Somebody probably added a tlog when they ran out of space in the first one. So your issue is that you are using FULL recovery model and aren't performing transaction log backups. With FULL recovery model, you must perform regular tlog backups. We run our tlog backups every 15 minutes. If you don't want to do this and don't care about
point in time recovery (can...
Started 2 weeks, 4 days ago (2009-12-10 06:19:00)
by rajdaksha
>
Hi You mean this... IDENT_SEED Returns the original seed value ------------------------- R...
Started 4 weeks, 1 day ago (2009-11-29 09:05:00)
by jackv
>
My standard is to split : 1)
OS 2)Data files 3)Logs files 4)tempdb Jack Vamvas -------------------- http://www.ITjobfeed.com (IT jobs)
Started 1 month ago (2009-11-23 10:27:00)
by tkizer
>
What
recovery model are you using? If it's FULL or BULK_LOGGED, then how often do you backup your transaction logs? Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with the premise that everything you've done up until this point is wrong."