aomanakkuttan (3/17/2009)

---

I have a SQL Server2005 SP2 'A'.Due to performance issues i want to move/replicate the same to Second Server 'B'.

How can i move the stystem databases?

Can i restore master...

I would drop the database and recreate it from the backup but does it make difference I am not so sure. Either ways database is going to be in the...

DBCC TRACEON(1222,-1)- Enabled the flag globally.

You get the graph in the Error log. copy it to a text file and post...

No problem at all.

Yes, you can do it either way

Script out all your objects at the source and then run it against your destination table.

No, not through backup and restore method, instead you can script out your 2005 database and then...

Poll your table using the dmv ' _physical_stats' and organize your maintenance plan.

As a genral rule of thumb Fillfactor should be:

100% for no activity

90% for low activity

70% for medium activity

50%...

t.walker (3/17/2009)

---

I'm not sure you can have...

You can never downgrade your database. it is not possible to restore a 2005 backupfile onto a 2000 server, same thing with the 2005 and 2008.

That sounds good to me, but how heavy is the table getting modified. 90% FIllfacotr prone to more page splits, if have this setting and if there is huge...

as ALZDBA suggested put your DB in single user model it should kick everyone out and then restore the database and fix the Orphan users

You are trying to truncate the Transaction log. tempdb is recreated each time the sql server starts. You should always size your tempdb...

Please give us some clarity.

Helo Ratheesh,

I would not want to try that. I want to know what you are trying to do? I did so, and I...