I don't know how to do that nativelly in SQL 2005 but Red-Gate SQL Backup could be a good 3rd party software.

Thanks to all, but my mistake, email went to junk! What a beginner mistake

Nice job, I’ll use it for sure.

I was using, since always, Left 4 of a new guid +...

No, it’s not true. Consider using SQL 2005 Workgroup Edition or even SQL Express.

Nothing special,

Set SQL server to run under a domain account, an account with less permission as possible on the network (nothing is the best). Then grant access wherever you need to...

I will suggest to protect this share, only allow permission to SQL service account and DBA +(some admins if you want).

Because the backups are not really protected anyone with SQL...

Bizzare, maybe you can try to script the action in SSMS. Just to see what is the difference!

Good thing it's working!

I agree, take regular bakups and you'll be in good shape!

I do not use this kind of authentication, but it look logical to have a kind of both way authentication.

An easiest way will be to use "be made using this...

humm, interesting...

maybe the kerberos thing. have you tried, with your setup, to execute the query directelly on the sql 2005 server.

Maybe you should consider to execute the script even if...

Well, if you do regular backups and maintenance, using maintenance plan, rebuid index, check data integrity, ect... You should be good.

With this backup strategy i think you're covered!

Well, a good approach is to create a windows Group, maybe something like “SQL User” and add only this group in SSMS, add it as a login, and...

Hi Abhishek,

It depends on how many data you can afford to lose.

If you can afford losing a full day of data,...

Are you using mixed mode?

Maybe your user is not in a granted windows group, which make your windows authentication to fail.

And if mixed mode is not set, that will fail...

Bonjour,

Are you in a 64 bits environment? Probably yes!

You have to execute against your SQL 2000 a script found into the service pack folder. "instcat.sql".

This will update some system table...