I also registered a case at Microsoft support. They helped me with the solution.

You do not change the ports in the "C:\Program Files (x86)\Microsoft SQL Server\90\Shared\ASConfig\msmdredir.ini" file, but in the...

Gail,

I don't worry that much about the MDW, it is just one of our "larger" databases and because it is only for supporting the IT staff it is a nice...

Jeff,

the solution you suggest is a possibility for application I (or my company) have created. This application (MDW) is created by Microsoft, so it refers to the table name they...

Gail,

thanks for your reply.

We already do a mixture of reorganize and rebuild of indexes based on their fragmentation level

I see that also the standard edition of SQL 2008 R2 supports...

:w00t:

I have changed the /* Tranfer data */ part to the code below and I have removed the /* Update column numVal to random numbers */ part

/*Create source...

I also found this. I haven't tried it yet, but reading the eventlogs through SSIS is also a very nice method.

http://www.softpedia.com/get/Internet/Servers/Server-Tools/SSIS-Event-Log-Source.shtml

This package provides an SSIS 2005 Data Source...

Gail, Steve,

thanks for the replies. I always thought the data file was the most vulnerable file, but that can be restored until the time of the crash with a tail...

I have found my solution at this link:

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/f4842c73-6439-4fc0-ad59-cf74f9ef7b83

Regards,

Marco

I'm having the same issues, does someone have a solution for this. I have tried a lot of options in the "error output" tab (redirect row and ignore failure), but...

Sorry, I didn't mean grow 60% but fill up to 60% (60% of the log is in use).

Regards,

Marco

it is indeed a good idea to backup the logs more frequently, but when the logs grows over 60% between two backups it is a good idea to make an...

You can also let this alert make an automatic T-Log backup when it reaches the treshold, so the log doesn't have to grow at all.

Regards,

Marco

I don't use impersonate. When I look on the security tab of my linked server this option is not marked.

You can check which user you are by running te command...

The poster wants to know if the migration interrupts the insert query which is running. This was a query which continuously inserts data.

You can also immediately delete the data after...

I have two servers:

- SERVER01

- SERVER02

- On SERVER01 I create a SQL user named "SERVER01_User" with access to the table "SERVER01.test.dbo.sysobjects"

- On SERVER02 I create a SQL user name "SERVER02_User"

-...