June 5, 2009 at 2:14 pm
Hi Room,
Can anyone advice and help on how to setup SQL Server 2008 backup best practice?
I wanted to backup my SQL Server 2008 databases into Server_B D drive.
I created a share folder "Server_B_Backup_Folder" and granted the security access.
Thanks in advance.
Edwin
June 5, 2009 at 2:29 pm
What specifically do you want to know?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 8, 2009 at 7:32 am
Hi Gail,
I run into problems when I tried to setup the backup into
"Server_B_Backup_Folder".
The specific folder cannot be use or accessable..something like that..
My backup plans:
1. Full backup on Saturday at 1:00 AM
2. Transaction Log backups on every 4 hours
3. Differential backup on Monday, Wednesday, and Friday
Please help and advise.
Thanks,
Edwin
June 8, 2009 at 7:37 am
If it can't access the folder, it's because of security. SQL Server runs under a different context than when you connect to it. Just because you can access the share doesn't mean the security context that the server is running under can. Find out what context SQL Server is running under and then verify that it has access.
Also, it could just be a typo. Make sure you have everything defined correctly.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 8, 2009 at 12:32 pm
Hi..I figured it out. Thanks,
Ediwn
June 8, 2009 at 12:55 pm
Just so the next person along can understand, can you post the solution?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 8, 2009 at 12:58 pm
Just for interest, it's usually recommended that the backup be done to local disks and then copied to the network. Firstly because of the speed of local drives vs the speed of the network. Second because if there's a network glitch during the backup, the backup will fail.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply