for the last 7 years I have used different 3rd party products - Legato, Veritas 8, 8.6, 9, even the expensive ComVolt Galaxy, and ,of course, the regular SQL backup...

I started this posting a couple of months ago and now after all this time, I'm still having the same problems - suspected databases daily, long waiting time (time to...

Thanks a lot.

I also could use a tool like VEdit to clean the file and then to load it with DTS.

Thanks again.

MJ

Currently I do not need to execute any DTS Packages from VB. My VB program puts all the data straight to a SQL table.

My question was if there is the...

I had the same problem with one of my developers - the best practice is to develope the DTS packets locally on the SQL server, so they could run with...

I'm constantly transferring VFP 7 data to SQL 2000. The best driver to use is VFP OLE DB coming with VFP7. The easiest way to be sure you have...

Thanks a lot, Brian.

Oh, well, my security is not so complicated, but I have to support very old set ups...All new SQL servers work with user-defined db roles, as for me...

No, this is the ptoblem. The old NT will be gone and the newtwork guys refuse to establish any connections to the new AD domain. They said they'll rebuild all...

Thanks a lot.

I did adjust the time-out with the initial SQL server installation - I usually do that for every server as we are having network problems all the time. After...

Yes, this is the problem - that's what worrys me so much - there will be no one of the old users left. We have a new boss and he...

DBCC TRACEON(1807) did not work at all. That was the first thing I tried.

The problem is that I'm not sending the files to the NAS, but the oposite - SQL...

It did work. Thanks a lot.

Only if you try to create a backup device, it still gives the error:"Network path not found", but the device is created and I could...

I understood - SQL transaction log files. To change them in the Server property will reflect only newly created Dbs. The script I posted shows how to move user DBs...

Thanks a lot.

You are right, but there are about 300 entries in the log and was worried about...I'll ignore it.

Thanks again.

MJ

Here is the steps and the code I use for years... Hope it helps...

USE DB_Name

go

sp_helpfile

go

--it'll give you files locations like:

E:\datafolder\MSSQL\Data\ENT_DATA_Data.MDF                                                                                                                                                                                                                

E:\datafolder\MSSQL\Data\ENT_DATA_Log.LDF                                                                                                                                                                                                                       

  --detach theDB                                                                                                                                                                                                       

USE MASTER

go

SP_DETACH_DB 'DB_Name'

GO

--Minimize QA and copy AND PASTE...