kesmond (6/21/2011)

---

hmmm... how come now when i restore the transaction logs file, my database is gone? only have model db transaction logs and other db transaction logs? anybody know why?...

I need some suggestions of a backup plan that has backups for FULL, INCREMENTAL and LOG backups, which factors in the relationship of the 3 backups.

SQL server doesn't has INCREMENTAL...

@ashkan siroos

i suggest you to read grant fritchey's perfomance books. It will clear your doubts.

@Warwick rudd

I think its not real time issue.

kesmond (6/20/2011)

---

i gone thru the link that u have provided. but just have doubt over the transaction logs restore, as what i have painted on the scenario, we have to...

kesmond (6/20/2011)

---

thanks for the prompt reply. But lets say example, i do a full backup on monday and a differential backup daily and transaction log daily for every 5 mins....

kesmond (6/20/2011)

---

Dear all,

just to check with you. for restoration of database, i would need to perform the following:

I did a full backup at around 1pm today. and a differential backup...

I can't open your attachment.

Can you tell your prob

Mike Austin-398977 (6/16/2011)

---

Hi all,

In a previous incarnation as a Sybase DBA (on Unix), I created, or used, checklists for performing DB refreshes, re-synching replication, trouble-shooting various error conditions, etc.

These checklists,...

SQL ORACLE (6/15/2011)

---

The weird thing is, I have sa permission on the database server and local admin permission...

I see there are some sharepoint delete expired session jobs run every minute , that could cause the blocks at peak time.

Is it a job needs to run every minute?

I...

83 SUSPENDED . WSS_Content_Collaboration SELECT 76640 468108

83 SUSPENDED . WSS_Content_Collaboration SELECT 78281 479179

83 SUSPENDED . WSS_Content_Collaboration SELECT 96500 575951

Hi sqlfriends,

First check your share point content DB and table size and...

kvr1985 (6/15/2011)

---

muthukkumaran Kaliyamoorthy (6/15/2011)

---

i second that grant. Alert is good option but it's not work all the cases.

If you want you can use my beat version Sproc and add the...

i second that grant. Alert is good option but it's not work all the cases.

If you want you can use my beat version Sproc and add the errors whatever, you...

Paul Farnell (6/15/2011)

---

We have an application we bought which runs a SQL Server 2008 Express backend. We have had an interesting incident over the weekend where 2000 records have...