george sibbald-364359 (9/23/2009)

---

yes, they can be changed independently, BUT, when a database backup command is run it is run by the database engine NOT SQLAgent, I think this maybe why...

I have changed the SQL Server Agent account's login and restarted this service. I have changed the SQL Server Service but have not been able to restart this service yet,...

I'm still not sure how to resolve this error, other than copying the files to a local drive on the Production server and then copying these files to the fileserver...

Ah, well spotted. It is. Its because I ran the procedure afterwards with the 'Servername/DBName' path (which clearly doesn't exist)

The error is in fact:

Msg 3201, Level 16, State 1, Procedure...

Thanks Silverfox.

I've attempted your suggestion but it still returning the same:

Msg 3201, Level 16, State 1, Procedure spTestingBackup, Line 11

Cannot open backup device '\\ServerName\DB_Backups\DBName\DBNameFull_20090923_1233.BAK'. Operating system error 53(error not found).

Msg...

Ah ok, I see what you mean now.

How am I to run the command within the query using the domain account? Also, using xp_cmdshell will I still be able to...

Yes, this is what myself and the network admin have already tried! We can navigate to the folder no problem and create a test text file in the folder as...

I'm sorry I forgot to add that. The destination folder IS a share and the share permissions on the folder have been set to 'Full control' and the SQL Service...

Yes, it is what i'm doing.

I didn't quite understand what you said in your first post, but now fully understand.

I've just updated the client tools on my local machine and...

Sarab (8/24/2009)

---

See the service packs are commulative for SQL Server as a whole.

Try to run the following commands on your SQL Server and see what comes.

exec sp_server_info

go

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),...

matt stockham (4/21/2009)

---

You should also ask the developer about permissions required by the app(s) as this will dictate how tightly you can secure the logins. There really shouldn't be...

Brandie Tarvin (4/21/2009)

---

Dan,

I'm a little confused. Are you trying to create logins on a user-by-user basis or on an application-by-application basis?

I previously thought you were talking about the later. Now...

Richard M (4/21/2009)

---

Gift Peddie (4/21/2009)

---

When you add your intranet users in your AD group make sure you also add them manually into SQL Server and the databases used by that...

Ok thank you both for this.

We have ~150 users who would be looking to connect via these applications that are external to the company (i.e. not in our domain). As...

The other thing to bear in mind is how often you are capturing the data. I've read guides where its recommended to change the default value of how big the...