So what does your windows hostname command return. It should return ABC-CDEFGHI-JKLM. If not then the problem starts there itself else its somewhere in sql data engine.

create

function function_test

(

@input varchar(30))

RETURNS

TABLE

AS

RETURN

(

If disk is damaged then you can call the vendor for help they will have few tools to recover data from disk depending on the hardware.

I have seen this error when the windows account has locked out and SPN problems.

The database was in full recovery mode. The data was initally loaded and backup taken the data that was loaded will be there in log file and hence both are...

It is used to backup the currently active transaction log.

If its a default instance then it should be same as server name but here its one letter short. Anyways just do a select @@servername and check. Also do a...

Lot of Bugs has been fixed in SP1 and SP2. Just check microsoft site for that they have listed number of bugs being fixed in SSIS and MP.

My suggestion too is the same. Go for disk backup and move the disk backup to tape.

Do a checkdb of the db to check if it has any tornpages. Tornpages might cause CRC issues with backups.

hi Chandra

Did you test this.

Red Gate SQL Compare also has data compare with it whcih can sync data. Also look for Quest tools. then there is SQDelta and more.

Then you need install DB2 client components.

This article in the link says how to add the key and does not describe on how to modify the already set up licensing. I am interested in knowing how...

Always you can use this we you want to remove the unused space from the log file and reserve that to OS.