Before I answer your question, how many rows are you expecting on average?

It affects how I tell you..

CEWII

I guess when I was asking about the versions I was asking about changes to the back-end. Were there any processes that were re-architected? Were there new processes...

Visual Studio SP1 perhaps?

CEWII

Are you trying to do this from script or from the GUI?

It needs that secondary data file, and you can remap it to another location but you need that file....

I don't think that statement applies to what you are asking which is basically about a backup drive and NOT the drives that hold the data files for SQL.

In a...

At first glance this link seems to cover baiscally what you are asking about:

http://social.technet.microsoft.com/Forums/en-US/winserverMigration/thread/e5b31427-a191-41b6-acc7-19365d230873

CEWII

That is a really good suggestion, I agree, I don't see any real reason to do this in SSIS..

CEWII

Your latter suggestion sounds like a VERY workable plan.

CEWII

As far as access, ask your network admin's, there is no good reason for that to be the issue.

As far as in one place, that is fine, but I still...

Maninder S. (5/4/2010)

---

If this DB is a critical database, then:

Daily Full Backups / 4 hour Differential Backup / 30 min Transaction Log Backup

If the database is very Critical and heavy...

eric_russell 13013 (5/4/2010)

---

If someone is developing something like a desktop application for release as shareware, and they feel it's important to protect the contents of proprietary reference tables and SQL...

I generally agree with GregoryF, you haven't provided us much..

How is the new app different than the old?

Also to detect memory problems I have this:

http://www.sqlservercentral.com/Forums/Topic909689-146-1.aspx

You should confirm a memory issue...

Using (local) and such is almost always a great idea, it makes it easy to move things server to server without change and I applaud that..

However, in a clustered environment...

I'm aware of no defects related to that. I would venture to guess that someone did indeed do it and not even realize it. So they aren't lying....

princa (5/4/2010)

---

Elliott W (5/4/2010)

---

Step 1. I'm not talking about using the transfer objects at all, Step 1 is a backup and restore, which can be be in an SSIS...