the cost is onl

lessons

transaction replication should solve ur problem

right click on maintanence plan, select modify option & right click on the maintanance plan task that opens on Visual Studio & select the disable option. Hope this helps

check the size of ur transaction log. also check the size of the logical drive. If it is almost full, then it may take time.

it looks like he is talking about the growth of the log files (ldf). specifically it needs to be analysed why the log file growth? r u performing any transaformation...

Hi guys,

take a look at this article. Maybe it could throw some light on ur issue. Carefully read the note highlighted in red.

Courtesy: http://www.mssqltips.com/tip.asp?tip=1324

Regards,

Rajesh

Problem

In two previous tips...

Hi Samata,

I would really appreciate if you could post the exact error that you get while using SSIS sked.

Regards,

Rajesh

hi pal,

Just create a package (SSIS) to move the data from production DB to archive DB. Schedule that package to execute once in 15 days. But ensure that you truncate...

Hi Itoso,

WARNING: The built-in SA user account is installed without a password. This enables you to connect to MSDE initially. However, if you enable SQL Server Authentication, you must create...

hi,

splitting of CAL's is not possible.

hi Itoso,

Ensure that you are behind the firwall if it is a web server/sql server.

Hi,

backup & restore is the best way to move databases from one box to another. Copying mdf & ldf is a bad practice.

Regards,

Rajesh

Hi buddy,

thx for enlightening us with some useful tips. More or less this is what we had been expecting & require. Regarding the modes you have mentioned i have few...

thanks mentalWN...lol.. 😉 finally i see some light at the end of my tunnel...could you provide me with some documentation sort if possible the way you people are replicating...or gimme...