The databases were in simple recovery mode. I changed them to full recovery mode, but to run the log backup successfully had to re-run a full backup while the database...

Hi

thanks for the responses. Makes sense. Do you have any suggestions how I can track what takes up that time? Ie. what events do I set up in Profiler once...

Hi

thanks for the responses. Makes sense. Do you have any suggestions how I can track what takes up that time? Ie. what events do I set up in Profiler once...

Hi

Have a look at these 2 links.

http://support.microsoft.com/?scid=316005

http://www.perfectxml.com/Articles/xml/importxmlsql.asp

Right click on the workflow (sometimes you need to check both the preceding and following workflow). Select properties. Add the new precedence criteria. Make sure you update the precedence that...

I have copied (probably somewhere from this site ) and used the following probably with some modifications from the original.

CREATE TABLE AdminReindexDuration (

 DBName varchar (255) NULL ,

 DateStart datetime NULL ,

 DateEnd...

Don't know why but this solves it....

DECLARE @a NCHAR

SET @a = '-'

SELECT datalength('a1sdsad12---325143gffdfd4dgsf1 -')

      -

      datalength(convert(varchar,REPLACE('a1sdsad12---325143gffdfd4dgsf1 -',@a,'')))

1. Backup the MSDB and restore on new server but you will over write any jobs already on the new server. So be sure there is nothing you need. If...

Try running this statement against the databases in question.

 sp_spaceused @updateusage = 'TRUE'