Server Side Traces?

But that would be an additional overhead on the server even to the extent of slowing down the server and even crash the database in some situations..

Why do...

And the database should be in full recovery...

Am Glad it worked!!:-)

The workaround to this problem is:

1. setup replication (i dont hv answers as to why you need to setup replication).

2. delete replication

3. backup tran log

4. shrink tran log(if its urgent)

chandio11 (9/13/2009)

---

1) Clusterring

2) Dividing the databsae into two separate databse to be hosted on different servers so that requests can be distributed.

3) Placing the highly transaction tables on seprate file...

It's always a best practice to run upgrade advisor which lists all potential problems beforehand so that you can prepare well. Backup/restore is a good way to migrate databases. Once...

SAT_SQL (9/12/2009)

---

Hi

I want to implement the replaction for on of my client , please provide the available source , and step by step methods , and any links...

You should go through the articles that Paul pointed you to read.

It seems your database is in full recovery mode. Are you taking regular log backups?

If recovery to point in...

Please go through http://msdn.microsoft.com/en-us/library/ms179530(SQL.90).aspx.

Scripting should ideally bring job steps as well.

There is another method... Import the table contents of sysjobs, sysjobsteps and sysjobschedules tables from msdb database of the source server to the...

Pls go though this thread: http://www.sqlservercentral.com/Forums/Topic785497-146-1.aspx

It contains a link to a blog. pls read that as well.

Now if suppose i have to restart the Log shipping then :-

1. is it possible to take the Tlog backup from the Primary Server & restore it to secondary...

amarbreddy21 (9/8/2009)

---

Hey Experts

Hi all iam new to sql server.i had a small dout.

1.What is fileGroup(Is that .mdf and .ndf or...

Vicky (9/9/2009)

---

Dear friends,

Can we back up selected tables from a database in SQL Server 2005?...

duplicate post:

please post your replies to http://www.sqlservercentral.com/Forums/Topic785531-357-1.aspx