I mean to say we have achieved them... but still need...

I need to automate

Backup and restore of databases.

User creation.

Database creation/copy

Peter Maloof (5/14/2012)

---

By 'incremental backup' do you mean 'differential backup' or 'transaction log backup'?

If you mean differential, then do you really want to delete them? If you're not doing transaction...

[font="Courier New"]You can use this cursor........

DECLARE @name VARCHAR(50) -- database name

DECLARE @path VARCHAR(256) -- path for backup files

DECLARE @fileName VARCHAR(256) -- filename for backup

DECLARE...

http://images.google.com/search?tbm=isch&hl=en&source=hp&biw=1366&bih=587&q=sql+server+architecture+diagram&gbv=2&oq=sql+server+arc&aq=3&aqi=g4g-m2g-S4&aql=&gs_l=img.3.3.0l4j0i5l2j0i24l4.93.11512.0.14757.22.19.1.2.3.0.359.3666.2-8j5.13.0...0.0.F8d7usUXuc0

1) Open SQL Server Management Studio or SQL Enterprise Manager (based on your SQL version/edition).

2) Connect to specific Instance of SQL.

3) Right click on database whose data files you want...

GilaMonster (4/20/2012)

---

For a user database it'll work if you change the file name to where you want the files to be. Once you've run that, take the database offline, move...

Replies are appreciable..... Thank you guys...

Create and sync subscriber using SQL server powershell script.

is anyone have the script??

I have solved this problem..... Alerts are properly configured and executing on event.

Problem was at the policies for which I was configuring alerts was in On Demand mode.... It has...

Hi...

just want to know whether to create alerts on The server where CMS is configured??? or each registered server I will need to create alerts...

Image number 1 & 2 representing operator screenshots. I named operator as Alert.

Image of agent alert...

anthony.green (3/12/2012)

---

thanks thats the alerts and errors checking out fine, but can we see the rest, dont need to see email addresses etc so you can blank them out its...

Please find attached...

anthony.green (3/12/2012)

---

Has this server sent mail before successfully? If not might be AV blocking mass mail worm or something blocking port 25 for SMTP or something along them lines

If...