sivark1 (4/15/2010)

---

This task Now we r planning to go new server(DELL R410)for Sql 2005 Enterprise Edition with Win server 2003 enterprise edition.

so migration is not in the same server it...

I quite like the term 'upgradation'... we all knew what the original op was trying to say!

A quick search within SSC will produce numerous topics on the subject of upgrading...

We're currently using Redgate's SQL backup Pro product and getting 96% compression on a 106GB database, backing up to approximately 4.4GB and taking around 2 minutes!

Norwich, Norfolk, UK

Better still...

SELECT SERVERPROPERTY('productversion') AS 'SQL Build', SERVERPROPERTY ('productlevel') AS 'Service Pack', SERVERPROPERTY ('edition') AS 'SQL Edition' Order by 'SQL Build'

Rem,

Check out this link

http://www.sqlservercentral.com/articles/Administration/2960/

even has links to Cumulative Updates!

Many Thanks Brian for a very informative article for someone who is only now beginning to dabble in SSRS.

I have a question...

Let's say I want to run this report against...

Durai,

Another Accidental DBA lol... welcome.

This topic has been covered many times before within these forums. I would be inclined to search the site first as you will find plenty...

Hi Tara,

I personally would choose MS Visio to do this but that's just personal preference. When you say granular, how granular do you mean? With Visio you can...

Checkout this msdn link http://msdn.microsoft.com/en-us/library/ms143504.aspx

Hi Shark,

If memory is definately the issue and your running at maximum, can you not add some more physical memory to the host and therefore assign more RAM to Server...

LOL - thanks mate

@ Ian Scarlett -...

hmmm... can only seem to...

Thanks for all the responses. Lowell that's exactly what i'm after do you know of a free alternative to EditPlus?

Cheers,

Mark

You'll be lucky Chandra! My Technet subscription shows that I can download 2000, 2005 & 2008. I've not seen any links to SQL 6.5 & 7 for years......