|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > backup sql to network drive at nights?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
backup sql to network drive at nights?
|
|
|
| Well i am sure it can be done with switches in a script but how?
| |
| Catelin Wang 2002-11-19, 2:23 pm |
| You can schedule a job running at night. here is a example on the network
path :
BACKUP DATABASE Pubs TO DISK='\\BackupServer\AllBackup
s\Pubs.BAK'
"Kris" <kkancler@etownsend.com> wrote in message
news:da52b3f5.0211190939.33f50bfb@posting.google.com...
> Well i am sure it can be done with switches in a script but how?
| |
|
| "Catelin Wang" <cwang@cemstone> wrote in message news:<efXRYJAkCHA.3576@tkmsftngp08>...
> You can schedule a job running at night. here is a example on the network
> path :
> BACKUP DATABASE Pubs TO DISK='\\BackupServer\AllBackup
s\Pubs.BAK'
>
>
>
> "Kris" <kkancler@etownsend.com> wrote in message
> news:da52b3f5.0211190939.33f50bfb@posting.google.com...
> > Well i am sure it can be done with switches in a script but how?
But I am sure i would have to throw a net stop and start in there somewhere no?
| |
| Tibor Karaszi 2002-11-20, 6:23 am |
| No, the point is that this is a SQL Server command, executed by SQL Server. Hence you don't have
to (and can't) stop the SQL Server service.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Kris" <kkancler@etownsend.com> wrote in message
news:da52b3f5.0211192021.478258f9@posting.google.com...
> "Catelin Wang" <cwang@cemstone> wrote in message news:<efXRYJAkCHA.3576@tkmsftngp08>...
> > You can schedule a job running at night. here is a example on the network
> > path :
> > BACKUP DATABASE Pubs TO DISK='\\BackupServer\AllBackup
s\Pubs.BAK'
> >
> >
> >
> > "Kris" <kkancler@etownsend.com> wrote in message
> > news:da52b3f5.0211190939.33f50bfb@posting.google.com...
> > > Well i am sure it can be done with switches in a script but how?
>
> But I am sure i would have to throw a net stop and start in there somewhere no?
| |
|
| what are the steps needed to do this? Where do i start?
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> wrote in message news:<#jiTr6IkCHA.1688@tkmsftngp08>...
> No, the point is that this is a SQL Server command, executed by SQL Server. Hence you don't have
> to (and can't) stop the SQL Server service.
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
>
>
> "Kris" <kkancler@etownsend.com> wrote in message
> news:da52b3f5.0211192021.478258f9@posting.google.com...
> > "Catelin Wang" <cwang@cemstone> wrote in message news:<efXRYJAkCHA.3576@tkmsftngp08>...
> > > You can schedule a job running at night. here is a example on the network
> > > path :
> > > BACKUP DATABASE Pubs TO DISK='\\BackupServer\AllBackup
s\Pubs.BAK'
> > >
> > >
> > >
> > > "Kris" <kkancler@etownsend.com> wrote in message
> > > news:da52b3f5.0211190939.33f50bfb@posting.google.com...
> > > > Well i am sure it can be done with switches in a script but how?
> >
> > But I am sure i would have to throw a net stop and start in there somewhere no?
| |
|
| I tried to do the Over the Network Backup and i keep getting the error
"the file is in use", so again, i am thinking I need to do the Net
stop and start call. Your thoughts?
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> wrote in message news:<#jiTr6IkCHA.1688@tkmsftngp08>...
> No, the point is that this is a SQL Server command, executed by SQL Server. Hence you don't have
> to (and can't) stop the SQL Server service.
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
>
>
> "Kris" <kkancler@etownsend.com> wrote in message
> news:da52b3f5.0211192021.478258f9@posting.google.com...
> > "Catelin Wang" <cwang@cemstone> wrote in message news:<efXRYJAkCHA.3576@tkmsftngp08>...
> > > You can schedule a job running at night. here is a example on the network
> > > path :
> > > BACKUP DATABASE Pubs TO DISK='\\BackupServer\AllBackup
s\Pubs.BAK'
> > >
> > >
> > >
> > > "Kris" <kkancler@etownsend.com> wrote in message
> > > news:da52b3f5.0211190939.33f50bfb@posting.google.com...
> > > > Well i am sure it can be done with switches in a script but how?
> >
> > But I am sure i would have to throw a net stop and start in there somewhere no?
| |
| Tibor Karaszi 2002-11-26, 1:23 am |
| What exactly do you mean by "Over the Network Backup". Where do you see this option?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Kris" <kkancler@etownsend.com> wrote in message
news:da52b3f5.0211250907.30986127@posting.google.com...
> I tried to do the Over the Network Backup and i keep getting the error
> "the file is in use", so again, i am thinking I need to do the Net
> stop and start call. Your thoughts?
>
>
>
>
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> wrote in message
news:<#jiTr6IkCHA.1688@tkmsftngp08>...
> > No, the point is that this is a SQL Server command, executed by SQL Server. Hence you don't
have
> > to (and can't) stop the SQL Server service.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
> >
> >
> > "Kris" <kkancler@etownsend.com> wrote in message
> > news:da52b3f5.0211192021.478258f9@posting.google.com...
> > > "Catelin Wang" <cwang@cemstone> wrote in message news:<efXRYJAkCHA.3576@tkmsftngp08>...
> > > > You can schedule a job running at night. here is a example on the network
> > > > path :
> > > > BACKUP DATABASE Pubs TO DISK='\\BackupServer\AllBackup
s\Pubs.BAK'
> > > >
> > > >
> > > >
> > > > "Kris" <kkancler@etownsend.com> wrote in message
> > > > news:da52b3f5.0211190939.33f50bfb@posting.google.com...
> > > > > Well i am sure it can be done with switches in a script but how?
> > >
> > > But I am sure i would have to throw a net stop and start in there somewhere no?
| |
|
| Actually there is no message. i am attempting to write a batch file. I
am not sure what parameteres I should be looking for. It looks like
when i try to copy the file when the sqlservice is running, I can't
but when i stop it, works fine, but how do i do so in a batch file? Ok
i know net stop, but what else should be included in this batch?
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> wrote in message news:<uHnB5oRlCHA.2000@tkmsftngp04>...
> What exactly do you mean by "Over the Network Backup". Where do you see this option?
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
>
>
> "Kris" <kkancler@etownsend.com> wrote in message
> news:da52b3f5.0211250907.30986127@posting.google.com...
> > I tried to do the Over the Network Backup and i keep getting the error
> > "the file is in use", so again, i am thinking I need to do the Net
> > stop and start call. Your thoughts?
> >
> >
> >
> >
> > "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> wrote in message
> news:<#jiTr6IkCHA.1688@tkmsftngp08>...
> > > No, the point is that this is a SQL Server command, executed by SQL Server. Hence you don't
> have
> > > to (and can't) stop the SQL Server service.
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
> > >
> > >
> > > "Kris" <kkancler@etownsend.com> wrote in message
> > > news:da52b3f5.0211192021.478258f9@posting.google.com...
> > > > "Catelin Wang" <cwang@cemstone> wrote in message news:<efXRYJAkCHA.3576@tkmsftngp08>...
> > > > > You can schedule a job running at night. here is a example on the network
> > > > > path :
> > > > > BACKUP DATABASE Pubs TO DISK='\\BackupServer\AllBackup
s\Pubs.BAK'
> > > > >
> > > > >
> > > > >
> > > > > "Kris" <kkancler@etownsend.com> wrote in message
> > > > > news:da52b3f5.0211190939.33f50bfb@posting.google.com...
> > > > > > Well i am sure it can be done with switches in a script but how?
> > > >
> > > > But I am sure i would have to throw a net stop and start in there somewhere no?
| |
| Tibor Karaszi 2002-11-28, 1:23 am |
| Why do you want to copy the SQL Server database files? The proper way to do backup in SQL Server
is to execute the BACKUP DATABASE SQL command...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Kris" <kkancler@etownsend.com> wrote in message
news:da52b3f5.0211270857.56bd4fb2@posting.google.com...
> Actually there is no message. i am attempting to write a batch file. I
> am not sure what parameteres I should be looking for. It looks like
> when i try to copy the file when the sqlservice is running, I can't
> but when i stop it, works fine, but how do i do so in a batch file? Ok
> i know net stop, but what else should be included in this batch?
>
>
>
>
>
>
>
>
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> wrote in message
news:<uHnB5oRlCHA.2000@tkmsftngp04>...
> > What exactly do you mean by "Over the Network Backup". Where do you see this option?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
> >
> >
> > "Kris" <kkancler@etownsend.com> wrote in message
> > news:da52b3f5.0211250907.30986127@posting.google.com...
> > > I tried to do the Over the Network Backup and i keep getting the error
> > > "the file is in use", so again, i am thinking I need to do the Net
> > > stop and start call. Your thoughts?
> > >
> > >
> > >
> > >
> > > "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> wrote in
message
> > news:<#jiTr6IkCHA.1688@tkmsftngp08>...
> > > > No, the point is that this is a SQL Server command, executed by SQL Server. Hence you
don't
> > have
> > > > to (and can't) stop the SQL Server service.
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
> > > >
> > > >
> > > > "Kris" <kkancler@etownsend.com> wrote in message
> > > > news:da52b3f5.0211192021.478258f9@posting.google.com...
> > > > > "Catelin Wang" <cwang@cemstone> wrote in message
news:<efXRYJAkCHA.3576@tkmsftngp08>... [colo
r=darkred]
> > > > > > You can schedule a job running at night. here is a example on the network
> > > > > > path :
> > > > > > BACKUP DATABASE Pubs TO DISK='\\BackupServer\AllBackup
s\Pubs.BAK'
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Kris" <kkancler@etownsend.com> wrote in message
> > > > > > news:da52b3f5.0211190939.33f50bfb@posting.google.com...
> > > > > > > Well i am sure it can be done with switches in a script but how?
> > > > >
> > > > > But I am sure i would have to throw a net stop and start in there somewhere no?[/color]
| |
|
| Yes i do agree with you but in the event the tape fails, i would have
this reduntant copy. Always better to have more the merrier when it
comes to backups!
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> wrote in message news:<uR5qW0qlCHA.2224@tkmsftngp02>...
> Why do you want to copy the SQL Server database files? The proper way to do backup in SQL Server
> is to execute the BACKUP DATABASE SQL command...
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
>
>
> "Kris" <kkancler@etownsend.com> wrote in message
> news:da52b3f5.0211270857.56bd4fb2@posting.google.com...
> > Actually there is no message. i am attempting to write a batch file. I
> > am not sure what parameteres I should be looking for. It looks like
> > when i try to copy the file when the sqlservice is running, I can't
> > but when i stop it, works fine, but how do i do so in a batch file? Ok
> > i know net stop, but what else should be included in this batch?
> >
> >
> >
> >
> >
> >
> >
> >
> > "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> wrote in message
> news:<uHnB5oRlCHA.2000@tkmsftngp04>...
> > > What exactly do you mean by "Over the Network Backup". Where do you see this option?
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
> > >
> > >
> > > "Kris" <kkancler@etownsend.com> wrote in message
> > > news:da52b3f5.0211250907.30986127@posting.google.com...
> > > > I tried to do the Over the Network Backup and i keep getting the error
> > > > "the file is in use", so again, i am thinking I need to do the Net
> > > > stop and start call. Your thoughts?
> > > >
> > > >
> > > >
> > > >
> > > > "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> wrote in
> message
> news:<#jiTr6IkCHA.1688@tkmsftngp08>...
> > > > > No, the point is that this is a SQL Server command, executed by SQL Server. Hence you
> don't
> have
> > > > > to (and can't) stop the SQL Server service.
> > > > >
> > > > > --
> > > > > Tibor Karaszi, SQL Server MVP
> > > > > Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
> > > > >
> > > > >
> > > > > "Kris" <kkancler@etownsend.com> wrote in message
> > > > > news:da52b3f5.0211192021.478258f9@posting.google.com...
> > > > > > "Catelin Wang" <cwang@cemstone> wrote in message
> news:<efXRYJAkCHA.3576@tkmsftngp08>...
> > > > > > > You can schedule a job running at night. here is a example on the network
> > > > > > > path :
> > > > > > > BACKUP DATABASE Pubs TO DISK='\\BackupServer\AllBackup
s\Pubs.BAK'
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Kris" <kkancler@etownsend.com> wrote in message
> > > > > > > news:da52b3f5.0211190939.33f50bfb@posting.google.com...
> > > > > > > > Well i am sure it can be done with switches in a script but how?
> > > > > >
> > > > > > But I am sure i would have to throw a net stop and start in there somewhere no?
| |
| Tibor Karaszi 2002-11-30, 3:23 am |
| I see. You could do a BACKUP DATABASE to disk as well, of course.
But, yes. To copy the SQL Server database file, you need to do NET STOP MSSQLServer (or the name
of your instance) first.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Kris" <kkancler@etownsend.com> wrote in message
news:da52b3f5.0211292010.432cb6f5@posting.google.com...
> Yes i do agree with you but in the event the tape fails, i would have
> this reduntant copy. Always better to have more the merrier when it
> comes to backups!
>
>
>
>
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> wrote in message
news:<uR5qW0qlCHA.2224@tkmsftngp02>...
> > Why do you want to copy the SQL Server database files? The proper way to do backup in SQL
Server
> > is to execute the BACKUP DATABASE SQL command...
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
> >
> >
> > "Kris" <kkancler@etownsend.com> wrote in message
> > news:da52b3f5.0211270857.56bd4fb2@posting.google.com...
> > > Actually there is no message. i am attempting to write a batch file. I
> > > am not sure what parameteres I should be looking for. It looks like
> > > when i try to copy the file when the sqlservice is running, I can't
> > > but when i stop it, works fine, but how do i do so in a batch file? Ok
> > > i know net stop, but what else should be included in this batch?
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> wrote in
message
> > news:<uHnB5oRlCHA.2000@tkmsftngp04>...
> > > > What exactly do you mean by "Over the Network Backup". Where do you see this option?
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
> > > >
> > > >
> > > > "Kris" <kkancler@etownsend.com> wrote in message
> > > > news:da52b3f5.0211250907.30986127@posting.google.com...
> > > > > I tried to do the Over the Network Backup and i keep getting the error
> > > > > "the file is in use", so again, i am thinking I need to do the Net
> > > > > stop and start call. Your thoughts?
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> wrote in
> > message
> > news:<#jiTr6IkCHA.1688@tkmsftngp08>...
> > > > > > No, the point is that this is a SQL Server command, executed by SQL Server. Hence
you
> > don't
> > have
> > > > > > to (and can't) stop the SQL Server service.
> > > > > >
> > > > > > --
> > > > > > Tibor Karaszi, SQL Server MVP
> > > > > > Archive at:
[url]http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver[/ url][
color=darkred]
> > > > > >
> > > > > >
> > > > > > "Kris" <kkancler@etownsend.com> wrote in message
> > > > > > news:da52b3f5.0211192021.478258f9@posting.google.com...
> > > > > > > "Catelin Wang" <cwang@cemstone> wrote in message
> > news:<efXRYJAkCHA.3576@tkmsftngp08>...
> > > > > > > > You can schedule a job running at night. here is a example on the network
> > > > > > > > path :
> > > > > > > > BACKUP DATABASE Pubs TO DISK='\\BackupServer\AllBackup
s\Pubs.BAK'
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > "Kris" <kkancler@etownsend.com> wrote in message
> > > > > > > > news:da52b3f5.0211190939.33f50bfb@posting.google.com...
> > > > > > > > > Well i am sure it can be done with switches in a script but how?
> > > > > > >
> > > > > > > But I am sure i would have to throw a net stop and start in there somewhere no?[/color]
|
|
|
|
|