Yes....

EXEC msdb.dbo.sp_send_dbmail

@profile_name ='SAGAR',

@recipients=N'ssonawane@systime.net',

@subject ='Policy Alert',

@query='SELECT TOP 100 [EvaluatedServer]

,[EvaluatedPolicy]

,[EvaluatedObject]

,[PolicyResult]

...

Divine Flame (2/9/2012)

---

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...

Complexity??? I guess no complexity will be there.... just found on web ....

Let's build a more complete strategy now: You can take a full backup every day, then diffs...

I mean If I schedule backup for F1

as

Full Backup (Everyday)

Differential Backup (Every 4 Hours)

Log backup every 15 mins.

what risk will be involved? in terms of time? or recovery??

You can configure email alerts for this.

And you can use free web services that can sms the emails arrived.

MysteryJimbo (2/2/2012)

---

Thats still pretty slim. I have more than that on my Windows...

Thank you Howard & Grant. I will try to make memory availability at least 8Gb

I have mentioned machine details that I am having.

I want to create 4 different SQL servers on 4 VMware clients(on single machine). Production, dev, QUA etc.

I want to test...

Please no one commented. 🙁

I want to create SQL Multiserver environment of atleast 4-5 Sql Servers .

I have scheduled Jobs for SQL backups. for daily, weekly and monthly.

Found last months backup output as 54217 rows.

manually its not possible to check job history.

Can you...

As I found query for backup history from msdb..backupset

select database_name,backup_start_date,backup_finish_date,type, backup_size from msdb.dbo.backupset WHERE (CONVERT(datetime, msdb.dbo.backupset.backup_start_date, 102) >= GETDATE() - 30)

ORDER BY

msdb.dbo.backupset.database_name,

...

Thanks TAVA for reply.

Actually I was seeking information for the failed backups in SQL Server. (Those backups which are not successful. We can notify it in error log, job...

please someone guide me...

It is the maximum server memory supported by SQL Server. You can calculate!!