maintenance plan

Using maintenance plan can make backup for another personal computerSorry, what is your question?
Ray Higdon MCSE, MCDBA, CCNA
--
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:%23JcQoyiCEHA.3344@.tk2msftngp13.phx.gbl...
> Using maintenance plan can make backup for another personal computer
>|||Hi,
Yes, You can store the Backup files in to a different personal computer, But
while creating the maintenance plan , While specifying the "Specific Backup
Disk Directory" you have to give the UNC path eg( If your Personal computer
name is 'SQL_PC' then you have to give \\SQL_PC\sharename . Ensure that the
SQL server service startup account have write access to the above share,
otherwise the backup will fail.
(Ensure that SQL Agent is Running all the time)
Thanks
Hari
MCDBA
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:#JcQoyiCEHA.3344@.tk2msftngp13.phx.gbl...
> Using maintenance plan can make backup for another personal computer
>|||[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'\\srvceprolab02\backup_sql\Contas_Tesou
raria_db_200403161817.BAK'. Device
error or device off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE i
s
terminating abnormally.
"Hari" <hari_prasad_k@.hotmail.com> escreveu na mensagem
news:u7kIK4jCEHA.2888@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Yes, You can store the Backup files in to a different personal computer,
But
> while creating the maintenance plan , While specifying the "Specific
Backup
> Disk Directory" you have to give the UNC path eg( If your Personal
computer
> name is 'SQL_PC' then you have to give \\SQL_PC\sharename . Ensure that
the
> SQL server service startup account have write access to the above share,
> otherwise the backup will fail.
> (Ensure that SQL Agent is Running all the time)
> Thanks
> Hari
> MCDBA
>
> "Frank Dulk" <fdulk@.bol.com.br> wrote in message
> news:#JcQoyiCEHA.3344@.tk2msftngp13.phx.gbl...
>|||Renato wrote:

> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]
[ODBC SQL
> Server Driver][SQL Server]Cannot open backup device
> '\\srvceprolab02\backup_sql\Contas_Tesou
raria_db_200403161817.BAK'. Device
> error or device off-line. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE
is
> terminating abnormally.
You need to make sure that the user SQL is running as has permissions to
access this network share.
Aaron Weiker
http://blogs.sqladvice.com/aweiker
http://aaronweiker.com/|||But would that be permission problem?
Because what don't get to see the mapped paste?
"Aaron Weiker" <msnews.SPAM@.aaronweiker.com> escreveu na mensagem
news:OjIg3E6CEHA.1588@.tk2msftngp13.phx.gbl...
> Renato wrote:
>
SQL
Device
> You need to make sure that the user SQL is running as has permissions to
> access this network share.
> --
> Aaron Weiker
> http://blogs.sqladvice.com/aweiker
> http://aaronweiker.com/
>sql