- Win (8/12/2014)

Making offline and online DB helps ?

NO!

Never take a DB offline if it's showing any kind of errors like this.

----------------------------------------------------------------------

I was just thinking around all the options....

Unable to shrink it, it shows 0 MB free space and utilized 58.9 GB

For for log_reuse_wait_desc - it shows NOTHING

Making offline and online DB helps ?

OR

Making DB to Full, backup,...

Hope this helps or gives a start...

1. http://www.ispirer.com/products/db2-to-sql-server-migration

SQLWays Tool Features for Migration from DB2 to Microsoft SQL Server

2. http://dbconvert.com/convert-mssql-to-db2-pro.php

Can you please elaborate ?

Hope this gives an idea.

http://blogs.msdn.com/b/clustering/archive/2012/11/21/10370765.aspx

Yes this configuration is supported.

Distributor version should be no earlier versions than the Publisher version.

Configure replication using SSMS 2012.

Thanks for your posts...

I tried to verify all in Idera, I am here just to find if anyone had such situation.

If we cannot clean the repository, then I guess it...

http://technet.microsoft.com/en-us/library/ms188371.aspx

Refer:

http://www.sqlservercentral.com/Forums/Topic710464-146-1.aspx

http://searchsqlserver.techtarget.com/tip/Different-ways-to-audit-SQL-Server-security

If it is in DR Test / Drill :

You need to failover to the Secondary / Target / DR instances & Databases and validate the Status.

Once the DR Test is...

check backup history on Primary. (Check for LSN numbers)

check Restore history on Secondary. From this you can come to know about if there is any latency between Backup & Restore.

Why...

Hello Jeff Moden,

Happy to see your response on this. I have couple of questions.

What do you mean ?

What should I understand with your response, the last lines ?

SSNs are encrypted...

Great help...!

I am planning to test the changes and code in DEV environment tomorrow.

I made this query into a Procedure and it is running fine as of now.

I will use...

I am Sorry for delayed reply...

I was away these many days.

Thanks for your help and options for better performance.

Yes, the job runs on Saturday & Sunday.

Thanks for your replies...

I will consider all of the posts and replies..