:w00t: :hehe:

I use SQLBackup from Red-Gate, price is nice and functionality is better than the price. I backup about 500 DBs and I can schedule the jobs, compress the files,...

:w00t::hehe:

Forgot to ad the following, there is an utility that comes with all Windows systems that will allow to set the aliases on each machine, but that is time consuming...

:w00t::hehe:

I initiated this trend a couple of months back due to the fact that we were moving forward with our consolidation project (went from 88 servers to 14) We use...

:w00t: :hehe:

It all depends on how your application connects to your data server. We just completed a consolidation project and had to use a mix of the DNS pointing to...

:w00t::hehe:

Nice article. One question though, I upgraded from 2000 to 2005 and now we are ready for 2008.

In the 2000 to 2005 I did rebuild the indexes after the...

Two ways of checking this out. First run SELECT @@VERSION and it will give you the version being used.

Second, if you upgrade your developer edition directly from the 2005,...

Thanks, it will be in 2005. One of the subscriber is not company own and they don't have plans to upgrade soon. Your answer and some research I have done...

😀 🙂 😎

Found the solution!!!

During the uninstall the registry kept a refrence to 90. I deleted teh key(after I bakced up the registry, of course!!! LOL)

After that was done,...

Just run the report to check any SQL realted products (see below) and got none, lost here. Suggestions? I reboot my laptop to make sure the uninstall went properly. I...

Agreed with SSCoach. 10 GB and leaving 6 for the OS is risking your SQL Server to run out of memory at one point or another. Better setting 8 for...

:w00t: :hehe:

The price is worth the R2 version. There are too many items coming in R2. Did you know that there is already a school of thought comparing Oracle...

:w00t: You allocated certain space for the database, but not all is used. Some is data, some indexes, etc. Every single object you create uses some space. At the time...

😀

That is great!!! Is there any article with step by step to do this? Is better to have it handy to avoid any mistake, don't you think? Appreciated 😀

By...

:w00t:

I think this are two different tasks and might be run at different schedules. First the shrink process, Many shrinks could create data corruption and this must done, at least...

Thank you Mark, that was exactly what I was looking for. 😀 :hehe: 🙂