Thanks for the reference!!!!!

Steve Jones

steve@dkranch.net

Just install it and reboot. the listener will pick it up on a reboot.

Steve Jones

steve@dkranch.net

Start with backups and restores.

Then it depends on what you are doing. What is your environment, what are you trying to support?

Steve Jones

steve@dkranch.net

Good points and thanks for the update.

BTW, wouldn't Oracle's RAW file be the same as the file used by SQL Server? all tables in SQL Server are contained within a...

Sorry, didn't read the timeout error. My guess is that there is a lock being held for some reason. Does the backup complete with no errors?

run sp_lock before and after...

Just tested with Pubs and it worked. Specify the new path on the second tab.

Steve Jones

steve@dkranch.net

Thanks for the followup and good work.

Steve Jones

steve@dkranch.net

Never seen anything like this. Are you r users members of some role? Have you checked the error logs for SQL and BakcupExec?

does this happen with a normal SQL backup...

Can you be more specific? There are lots of things that you need to do if you are adminning a server. BTW, this should be posted in the Admin forum.

I'd...

I'd recommend UDFs in SQL 2000 and a temp table in earlier versions.

Steve Jones

steve@dkranch.net

Send him this link. Tell him you "found it" during research.

Steve Jones

steve@dkranch.net

Thanks for the feedback. It appears that your Access database uses a different collation (kind of like language) than SQL.

Create a temp table and insert the data, then move it...

Glad to give opinions. Keep checking back, I'm sure Andy will weigh in tonight.

Steve Jones

steve@dkranch.net

Kind of. Personally I do the following:

Backup SQL to disk locally. gives me immeditate access to restoring dbs in case of data errors and allows fast backup.

Copy to remote disk...

yes, sorry. thanks. I meant disk.

Most people prefer backup to disk. At TechEd 2000, a number of the sql team also recommended this. Not to disparage vendors, but unless you...