Yeah it is a pain to get your head around, I had to do a full VMware ESX and SQL compliance project at the old place as they where very...

to add on from Gail's post, you haven't been doing regular TX log backups.

you now have a number of choices

backup the log to a new 2TB drive, shrink the log...

if you shrink by query or by job the syntax is the same, you just put a t-sql job step in and give it the t-sql.

DBCC SHRINKFILE(1,100) in a query...

is there a particular reason you cant use while loops or cursors?

How big is your TX log? 2TB? Or is the drive it is located on full?

run the following and return the results

select name, log_reuse_wait_desc, recovery_model_desc from sys.databases where name =...

first of all your DDL script is not complete, you reference a column in #temp called tax_ref_id which you have not defined and a variable called @tax_ref_id which again you...

Are you going down the route of each developer will have their own machine which have Hyper-V with a load of VM's SQL Visual Studio etc, or will it be...

Use the MAXAGE switch in robocopy and give it a values, eg 7 for 7 days,

This is the URL I use for robocopy switches

http://ss64.com/nt/robocopy.html

Thanks Lowell, it was the size of the gif, original one i had was 150x117, but managed to find an 80x80 and its working great.

Thanks alot

robocopy will do what you need, thats how we manage shipping BAKfiles from prod to DR, but use logshipping for TRN's to provide the DR so we dont need to...

alwaysgirl59 reported as spam posting

yes there will be downtime as the resources need to move from node1 to node2. the amount of time depends on the environment, in clusters I've worked with before...

you can assign at either host or guest level.

as you are using standard licences you can only host this at guest level

enterprise is 4 virtual machines at host level

data centre...

yeah it is the headbang gif, felt it was appropriate given some of the forum topics at the moment.

I will check the gif out on Monday for its size and...

Saggy (2/17/2012)

---

Date2/17/2012 8:59:07 PM

LogDatabase Mail (Database Mail Log)

Log ID7

Process ID6836

Mail Item ID3

Last Modified2/17/2012 8:59:07 PM

Last Modified Bysa

Message

The mail could not be sent to the recipients because of the mail server...