March 4, 2008 at 8:59 pm
Im having a problem in a server backup in another location
BACKUP DATABASE [testing} TO DISK = '\\SERVERNAME\SharedFolder$\Testing_20080305.BAK'
Error is as follows:
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\SEVERNAME\Folder$\testing_200803051149.BAK'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
I can open the shared folder and even create a word file in it but i cant backup a database
"-=Still Learning=-"
Lester Policarpio
March 4, 2008 at 9:26 pm
The service account for SQL Server needs rights, not your account.
March 4, 2008 at 11:24 pm
Both servers are using local system account is that ok??
"-=Still Learning=-"
Lester Policarpio
March 4, 2008 at 11:40 pm
You will need a domain account for this.
"Keep Trying"
March 5, 2008 at 2:02 am
How come I can run the script, put the backup to another server in the network which is set as local system account??
"-=Still Learning=-"
Lester Policarpio
March 5, 2008 at 3:23 am
From BOL
The Local Service account is a special, built-in account that is similar to an authenticated user account. The Local Service account has the same level of access to resources and objects as members of the Users group. Services that run as the Local Service account access network resources as a null session with no credentials.
Hope this helps
"Keep Trying"
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply