I tried the dbcc shrinkfile after taking a log backup but still the log file is not shrinking ...Is there any option to truncate log???

Thanks All,

The problem is that after reviewing the codes they said that EXISTS and TOP have...

Hi Sugesh,

Used the GUI ...first i detached the db and copied the...

Hi Faheem

I went through the link but no solution for my...

Are you able to see that in sql server surface area configuration??

Try giving port no in sql server configuration manager..

Think you have a nice and efficient maintenance plan on your mind.Go ahead.All the best.:D

I want to send a proposal to client who want to make a test environment which is an exact replica of production environment.His requirement is "how to buid a user...

Created a job for the maintenance plan and alert is made to email id but am not getting any alert.I have given the option after completion of maintenance plan the...

Many Thanks jsheldon

Thanks Dude its worked liked anything

😀

Can you please explain a bit more on that.

The machine to which i have to take backup is not in the same domain nor it have any domain.When i connect to that machine from the RUN am able...

you cannot connect remotly using alias name.you can connect to server using instance name .

I Think for your purpose you have to dettach the database and copy paste the log file to other array. In that case database will be offline.You can also try...