How often does the maintenance plan for transaction log run ?

vkundar (10/27/2008)

---

Thanks everyone !!

I am new to this forum.

I had faced the same backup issue and I followed the above steps and it was successfull.

Right now I have...

Or are you backing up across the network ? If so, times can be affected by other network activity.

Quintuple Post :w00t:

If you only want "new" records, then you have to put some logic in your DTS. Maybe run it once a day and use some date paramater to...

I think you meant QUINTUPLE :w00t:

We're going to run out of "tuples" soon.

Seggerman (10/24/2008)

---

A lakh (also written lac) is a unit in the Indian numbering system equal to one hundred thousand (100,000; 105). It is widely used both in official and other...

A shrink could help you with overall storage needs. If you have 50 G of...

krayknot (10/23/2008)

---

seenu_61281 (10/23/2008)

---

I would like to be a DBA in sql server.i am little bit stronger in sql queries,sp,views...

i know basic import/export thru DTS wizard.

What are the other things i...

Or isolate payroll on a separate instance of SQL on the same server. But then you'll need to buy another SQL license.

You can also set it to READ_ONLY if you want access to it, but don't want anyone to be able to change the data.

(Not what you asked, but just as...

Security and Backup & Restore strategies are the #1 thing for a DBA. Protecting the databases and making sure you can recovery in cases of emergency should be at the...

Do you understand that in SIMPLE mode, you cannot recover your database except to the last FULL backup ?

So, for example:

Thursday, 10 pm: Full Backup

Friday, 9 am ...

Change the owner of the job to a SQL service acct.

Yes, this relates to my other post about swapping out a drive. I need to move the files off the old drive, then back onto the new drive with the...

No history at all for any databases on the server ? It is possible to delete the backup history. Perhaps someone did ?