Check if you can access the remotely created DB with the credentials used by the connection using SSMS.

I guess you must create a user on the new database (and/or reconnect...

Migration from SQL 2000 to a new version (2005 or 2008) is possible, but if you want to migrate from...

ALZDBA (2/11/2009)

---

No, I said 8060 if the maximum row length for fixed length columns.

(N)Text needs to be replaced with (N)varchar(max). Those can contain up to 2GB of data (1 for...

As ALZDBA allready told, 8060 is the maximum number of characters that fit in NVARCHAR. If you really want to convert the NTEXT you must limit the amount of data....

Perhaps you can find the solution on http://msdn.microsoft.com/en-us/library/ms161561.aspx.

Pay special attention to step 10 from "configure and run the package" on that page!!

Can you post the error message?

And did you check the account of the SQL Agent service? Is it the same as the account compared to the server that executes correct?

To import data from other sources you can use SSIS. Any issues that can occur depend on your systems and needs. There is no way to tell you about it...

I suggest to use Windows Performance counters for CPU, memory and disk-IO usage. Run it for a day or a week to get clear knowledge of the servers performance. This...

I agree with William: I thought the question is which system databases can be moved. Therfor I didn't...

From the MSDN site http://msdn.microsoft.com/en-us/library/ms345392.aspx I read the following:

An identical view of reporting data from all servers.

This assumes that all of the server instances are configured identically, for example, that...

That's recommended for the data-files of the TempDB... (also keep them the same size)

madhu.arda (1/2/2009)

---

Hi hanshi,

as you said We added a scheduled job to change the setting to ON just before the REORGANIZE of indexes and a job to set it back to...

Schedule this command in a job to delete all backups that are older then 2 days:

DECLARE @Date DateTime

SET @Date = GetDate() -2-- determine date of day before yesterday

EXECUTE master.dbo.xp_delete_file 0,...

Thanks for all the replies...

I've stopped my trace and created a new one, now with saving results to a file...

Are you sure the job is running during the weekend? SQL itself is not aware of the weekday when running a job.