Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
noj17
Starting Member
18 Posts |
 Posted - 2008-12-04 : 21:11:48
|
| hi to all, i have read bol with regards log shipping, and i was able to go to the last configuration step. when i click finis, the backup job was succesful, but an error message appear saying "unable to copy initialization file to dest_server". What could be the possible error?both servers are registered under SQL server group...can anybody point out what i missed?any replies would be of great help^^thanks..!noj17 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2008-12-04 : 21:18:35
|
| The account that the SQL Server service is using must have access to the destination folder, to ensure that you'll need to use a domain account. |
 |
|
|
noj17
Starting Member
18 Posts |
Posted - 2008-12-04 : 21:22:37
|
| sorry, i wasnt able to get it,...does this mean i have to create anotjer sql gruoP?sorry, im a total noob in this...thanks!!noj17 |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2008-12-04 : 21:28:56
|
| No, nothing to do with the accounts in SQL Server, I'm referring to the Windows user account that SQL Server runs as - it will need file system permissions in order to copy the files.Take a look in the topic "Permissions" herehttp://msdn.microsoft.com/en-us/library/ms188698(SQL.90).aspxand a full description of the service accounts is herehttp://msdn.microsoft.com/en-us/library/ms143504(SQL.90).aspx |
|
|
|
noj17
Starting Member
18 Posts |
Posted - 2008-12-04 : 21:30:54
|
| thank you very much!!gotta read it now..^^ thanks |
|
|
|
noj17
Starting Member
18 Posts |
Posted - 2008-12-05 : 02:53:18
|
| uhm, ive just read the articles, and does this mean the same windows logon accounts? THe administrator ones? like the user accounts? I just want to make this clear...sorry, im just a little confused.thanks and gud day!noj 17 |
|
|
|
|
|
|
|
|
where could be the error?