Since it is a SAN storage built on RAID 5, you may not gain better performance whether or not you use either a single data file or multiple. However, you...

If the total space of data and log files is 6 GB, I cannot see any reason why the size of the restored database is 180 GB.

You may add a log file in your DTS package to find detail information.

It works.

We can prevent non-sa users from viewing the codes. On the other hand, we have to set DENY to each individual user/group.

Do I interprete your intention correctly?

Shark Energy (2/12/2008)

---

Anyone come across this?

I backed up a 3gb database on Server 1. Zipped up. Transferred to Server 2 (a virtual server). Unzipped. When trying to restore it says...

We need either a local or a domain account to start SQL Server.

We need either a local or a domain account to start SQL Server agent.

Where did you view...

Here are my inputs.

1. I cannot say 100%. But it should not have any problem in general.

2. dtProperties in SQL 2000 is a system used to store info for diagram.

Any...

Here are my input.

1. How often does your job run?

2. You provided the message for status of each step. But it is hard to analyze your question without any information...

How about this one?

SELECT * FROM sysjobs sj, sysdbmaintplan_jobs sdj, sysdbmaintplans sdp WHERE sj.job_id = sdj.job_id AND sdj.plan_id = sdp.plan_id AND plan_name = 'DB Maintenance Plan1'

Could you connect to the subscribers? It may be a connection issue.

Here is a link. May it help.

http://www.databasejournal.com/features/mssql/article.php/1459051

Here is my cent.

Using a cursor to partition by parts continuously or schedule a job to run periodically until it is done.

Did you check the collation on this column?

Are you talking about Query Analyzer in SQL 2000? We do use cursors in DTS without any issue.

It seems your query did not return unique value. Here is my input:

Run

select CONVERT (char(6),h.trans_date,12)

+substring (h.trans_number, patindex('%[^0]%', h.trans_number), 20)

from header h

where Siebeltransnumber IS NULL

and

select DISTINCT CONVERT (char(6),h.trans_date,12)

+substring (h.trans_number,...