Thanks Roy for correcting.. I am not aware of that..

Learned a point..

The screen shot indicates you are trying through surface area configuration. is that what you tried?

Try enabling the TCP/IP from the SQL Server configuration tools ( a restart is necessary).

Do...

May I suggest you this..

After importing the data from your flat file, can you move the flat file to a new location (you may need it if necessary) and at...

Look at the article link in my signature, you need to post some sample data that would give ready data to test and come up with the solution.

how can...

What...

GT-897544 (2/10/2010)

---

I agree with Gail, but diff backup takes almost same time and space as full backup again it depends. Personally i would prefer full back every night and log...

Yes it seems to be normal for the total size of the backup files..

I am not sure if I understood your question...

The question was already answered, you cannot.

May I ask you why do you avoid Linked Servers?

They are the way to talk to remote servers without having to duplicate...

Your post is confusing. You seem to mix-up the terminology here.

virtualpm (2/10/2010)

---

Hello,

We have a need to capture all transactions of staging database in a Data warehouse setting. We are...

laddu4700 (2/10/2010)

---

Ok.

data file and log file are in same drive. Once I move the db to another server, is it okay to put both files in same drive or log...

I second Gail's thoughts, shrinking causes fragmentation in the first place, and there is no significant amount of free space in your database to think about shrinking.

I am assuming...

Yes you can..

Setting up the distributor is the initial step in setting up Replication.., when setting up the common distributor, Add 2 publishers (one Dev and one Test)

For the second...

Have you tried using the Machine\InstanceName (if Named Instance) or only the ServerName..