Hi Experts,

Still looking for solid Business case which can impress my client to upgrade from sql 2k5 to sql 2k8 R2.

Your early .

Regards,

Bipan

These points are OK but do we have something on microsoft support side?

http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=SQL

Regards,

Bipan

You can troubleshoot it by modiying location of tempdb data and log files to another drive and then check if this problem still persist. If problem got fixed then try...

Better to use dbcc command on table wise rather than executing it on whole databases.It may lead space crunch if you dont hv enough in your machine.

MDX queries will help you on this.

Express edition has seprate SSMS.look for its exact binaries from google.

Delete this duplicate record in subscriber database manually.

Your patch file could be corrupted.Check windows event vciwer logs.

Hope you are not applying sp2 on sql server 2008 R2 edition as it sp2 is not yet released for this version.

It means you need manual logshipping if I am not wrong but that invloves lots of scripting and lots of checks from yourside.

Bipan

Wintel and storage team will help you as everything happening fine from sql server side.

So there will some configuration issue.

Bipan

Since your backup file are not fixed and count of these .bak files is changing everytime.

We can achieve this if you have knowledge of Java,C++ or DOS shell commands.

->You need...

Follow simple rule for data modelling:-

Identify the attributes(columns in tables) from project SOW.

Identyfing relationships among these attributes.

If you have one-2-one relationship then club all these attributes in single entity called...

Use TSQL restore commands to put in sql editor of job creation step.If you have issue in writing these scripts and use your SSMS to generate these scripts for you.You...

You can make use of sql jobs for this where you can put your multiple DB restore scripts and direct their output to file(You may consider it as restore log...