Zubius (2/15/2012)

---

If using the stored procedure below(scheduled or run manually), only 40 - 50 will backup with no errors -

(This stored proc is used on all other databases...

a.borgeld (2/10/2012)

---

Workshops say your server needs 1 GB for server processes. So mostly i do this.

16383 mb (it is in megabytes). 16 gig

2048 mb. 2 gig

16384 -...

Use the DMV sys.dm_io_virtual_file_stats to get the counts of reads & writes per database. You can easily compare the access pattern & utilization from the results.

If you are using them in excess then yes, they will also make the impact.

Lowell (2/3/2012)

---

My friend Jason pointed out that it assumes "CREATE PROCEDURE" , with a single space between CREATE and PROCEDURE exists...so if your prdoecure uses a different string...

sqlzealot-81 (2/9/2012)

---

GilaMonster (2/9/2012)

---

32 bit SQL on 32 bit OS is limited to 2GB of memory. Some (around 300 MB) is reserved (called mem_to_leave), the remainder is exactly that 1.6GB that...

Check the performance counter GeneralStatistcis:UserConnections for that particluar period.

deepikamm (2/2/2012)

---

declare @objid as int

select @objid=object_id from sys.objects where name='substitute your Procedurename'

if exists(select id from sysdepends where depid=@objid)

begin

select name as ParentProcedure from sys.objects where object_id in

(select id from sysdepends where...

NO!! I didn't get any spam mails ever!

You need to identify the queries which are generating these much logs. If you are doing some delete...

Yes adding the differential backup eases the restoration process & also they reduce the recovery time so they must be added.

However, as you said that you are going to take...

tototom (2/8/2012)

---

For those who wonder what happened to me. We lived with the nightmare for years. Backing up, restoring, application updates, etc. were all major problems.

Finally after years of...

Read...

Yeah right. I just used the word because at that time it felt like that ( the log file size increasing...

GilaMonster (2/8/2012)

---

Your database essentially becomes read-only, any operation that tries to make any changes fails. You would resolve that by finding out what is preventing the log from been reused...