This can be done ina easier way.

1. Restore the MSDB Database as msdb_test database on the server (this is just like any other user db restore).

2. Take backup of this...

Thanks Shaw.

How ever the issue was resolved after doing DBCC DBREINDEX on SyncServerState Table.

Here is the OUTPUt with the errors.

Server: Msg 8952, Level 16, State 1, Line 1

Table error: Database 'BESMgmt', index 'SyncServerState.PK_SyncServerState' (ID 946102411) (index ID 2). Extra or invalid key for...

Truncation does not reduce the size of a physical log file, it reduces the size of the logical log file and marks as inactive the virtual logs that do not...

1. back up the T-Log first using the command

BACKUP LOG MyDb TO MyDb_log

...

Truncation does not reduce the size of a physical log file, it reduces the size of the logical log file and marks as inactive the virtual logs that do not...

hi Gouthami Putra Sathakarni,

Can you please send the document regarding replication to me.

My id is nalini.devarakonda@gmail.com

thanks matt,

your solution really helped me a lot...

Thanks Lucky, but the thing is the particular table is comsuming very much disk space. what i'm planning to do is export it to an excel (once in three days...