Super Que. 😉

Hi Buddha,

Restore is the BEST option as SQL Server 2008 has lots of new system tables.

Happy Upgrading! 🙂

I "Lost" 2 points :angry: but "gained" a very good knowledge 🙂

I guess MS should change the title from "All System Databases (master, model, and msdb)" to "All System Databases (master, model, and msdb) etc." 😉

A simple but head scratching Question...! :crazy:

Many thanks.I learnt something new today ! 🙂

Or you can go for a following simple script =>

use databasename

go

select 'update statistics ' + name +' with fullscan ' from sysobjects where type='U'

copy the o/p and run.

Following could be the reasons that sparse file is getting bigger =>

1) lots of insertion/updation/deletion happening

2) not creating snapshots frequently (for eg. if you creating snapshot on weekly basis,then it...

To Control transaction log size you should take care following things=>

1) Dont keep the transactions open for longer time

2) schedule frequent transaction log backup

3) Schedule the index rebuild/defrag activities during...

Hope following links helps you =>

http://msdn.microsoft.com/en-us/library/ms144256.aspx

http://www.sql-server-performance.com/articles/dba/How_to_Use_the_SQL_Server_2008_Upgrade_Advisor_p1.aspx

http://msdn.microsoft.com/en-us/library/bb677622.aspx

Happy Upgrading... 🙂

Just an additional point to Gail's sugggestion is to check with your hardware.check whether you have any hardware issues on your server.If the root cause of your database corruption is...

Thnks to all Experts.This wil definitely help me a lot..:-)

You can try following steps

1)create a separate file group with diff name than primary

2)create a table on this file group using "ON" clause of create table with diff table name

3)move...

Hi Gail/Bru

Thanks For the nice reply....

Very first even I have suggested customer to go for mirroring but customer can't afford 3rd server (which we can use as a witness) then...

Adding additional differential backup on your existing backup policy may impact your performance(schedule it at non-peak hours).. and not to mention,you will have to preserve it to achieve the recovery..

Filling up of a page is totally depend on the row size of that particular table.

Just to add sql server can store only 8060 bytes of data on a single...