on one of our server tempd db grows upto 150GB and beyond. so we moved it onto a seperate disk. i have seen it goes upto 150 + and than...

thanks that make sense. I was under the impression that after t-log backup if space is not in use it should be released to OS.

if this is the case than...

no we don't use database mirroring. alway on as configured which was later disabled.

my concern is why size of log file doesn't reduce?

i created a ssis package. and doing data export from SQL to oracle in data flow task

thx for your response. i thought so.

thanks for your response guys. yes my aim is to point reads to node A and B and writes to Node A only. but to achieve this i need to...

thanks for your time. after struggling for a day and half i figured out what needs to be there in script so that it can pick all the file names...

as i mentioned earlier this is what i am doing and it works fine as long as file name doesn't change. my problem is file name changes every day.

i specified 2 varibales at package level and used then in for each loop and excel source connection

SourceFileName-- specifies file name can't use wild card doesn't work

SourceFilePath--specifies folder address

how to...

this is what i am doing and it works fine for multiple files. but when i have to execute the package next time my file name changed (new date time...

Ol'SureHand thank you so much for your reply.... your reply does make sense.. i will definetely want to recreate the scenario.. will try this on my test server.....

i detach the db on Instance2 and they were available on Instance1 but i wasn't able to view properties so end up detaching on both instances and attach on one.........

i configure the maintenance plans to backup all user databses on each instance at different locations. interestingly aaa database eas getting backed up by sql jobs on both instances and...

Thanks for your reply Jim.

i already detached the db from instance2 because it shouldn't be there. but i can't understand how it happened. and on the top everything was normal...