Hi Leo.Miller,

thank you for your comment, I have tried watching sample installation of AoHA on youtube and it states that 1 db is for read and 1 is...

Thanks DinoRS, sorry as I don't have experience on AlwaysOn Availability but does it work for read requests only? how about DML requests? Also from the sound of it I...

What is the version of your database server?

That's it sir? its bulk operation and export proc in EM is not? how about running same query (with where clause) in both bcp and EM? bcp will still use...

So what you want is to restore the latest backup? regardless if the backup is 1 or 2 days ago as long as it is the current one? are you...

hiram.osiris (12/27/2011)

---

Hello again, this is the modified script, I just made some readjustments in order to do what I needed. It still needs some readjustments.

Here's the scenario: We are...

hiram.osiris (12/26/2011)

---

Hello, I've gone deep into the script and I made some changes in order to take the last full and differential backup made. It still needs some readjustments but...

hiram.osiris (12/6/2011)

---

Hi

Thanks for the script, it is very helpfull, I just have one doubt, since i haven't gone deep into the script, is this script taking the last differential backups?...

pakwichek (11/10/2011)

---

Hello Sir,

I am using SQL 2008 and this beautiful script should help me a great deal as we are migrating from SQL 2008 and SQL 2008 R2

I...

Thanks for the replies guys the best I can do is to restrict the access of the user so that even with a successful registration in Enterprise Manager the user...

you can also try BCP with queryout parameter (if your into batch files)

Sailor (8/15/2011)

---

All of my databases are in subdirectories so I changed

SET @pathension = 'dir /OD/S '+@Path+'*20110814*.'+@Extension

Msg 3201, Level 16, State 2, Line 1

Cannot open backup device 'D:\sqlbackups\admin_backup_201108141900.bak'. Operating system error...

Sailor,

is this already solved? All backups are in subdirectories in d:\sqlbackups right? are they all .bak files?

I'll try to alter the script to solved the problem you are facing.

Thats right borce every time sql version is upgraded i.e. 2000 to 2005, I notice that they added columns on the tables used in the upgraded version. This is to...

Thanks Stakes for the comment 🙂