Hi All,
i want backup my SQL server (2005) but i do not have SQL agnet for backup
can i use follow script to copy whole database file and backup this file
with NTBackup? can it's backup be restore and work fine? pls advise.
net stop "SQL Server (MSSMLBIZ)"
xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1" "C:\Backup\BIZ"
/Y
net start "SQL Server (MSSMLBIZ)"
thanks,
William
yes this should work.
William Cheung wrote:
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1" "C:\Backup\BIZ"
> /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>
|||Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
Standard Edition (which includes SQL Agent.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:%23azj7ViAHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1"
> "C:\Backup\BIZ" /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>
|||Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
Standard Edition (which includes SQL Agent.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:%23azj7ViAHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1"
> "C:\Backup\BIZ" /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>
Showing posts with label agnet. Show all posts
Showing posts with label agnet. Show all posts
Thursday, February 16, 2012
backup
Hi All,
i want backup my SQL server (2005) but i do not have SQL agnet for backup
can i use follow script to copy whole database file and backup this file
with NTBackup? can it's backup be restore and work fine? pls advise.
net stop "SQL Server (MSSMLBIZ)"
xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1" "C:\Backup\BIZ"
/Y
net start "SQL Server (MSSMLBIZ)"
thanks,
Williamyes this should work.
William Cheung wrote:
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1" "C:\Backup\BIZ"
> /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>|||Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
Standard Edition (which includes SQL Agent.)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:%23azj7ViAHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1"
> "C:\Backup\BIZ" /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>|||Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
Standard Edition (which includes SQL Agent.)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:%23azj7ViAHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1"
> "C:\Backup\BIZ" /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>|||Arnie Rowland wrote:
> Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
> Standard Edition (which includes SQL Agent.)
>
I think that he means that he hasn't got the backup SW's SQL agent - not
the SQL Server Agent.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
i want backup my SQL server (2005) but i do not have SQL agnet for backup
can i use follow script to copy whole database file and backup this file
with NTBackup? can it's backup be restore and work fine? pls advise.
net stop "SQL Server (MSSMLBIZ)"
xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1" "C:\Backup\BIZ"
/Y
net start "SQL Server (MSSMLBIZ)"
thanks,
Williamyes this should work.
William Cheung wrote:
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1" "C:\Backup\BIZ"
> /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>|||Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
Standard Edition (which includes SQL Agent.)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:%23azj7ViAHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1"
> "C:\Backup\BIZ" /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>|||Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
Standard Edition (which includes SQL Agent.)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:%23azj7ViAHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1"
> "C:\Backup\BIZ" /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>|||Arnie Rowland wrote:
> Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
> Standard Edition (which includes SQL Agent.)
>
I think that he means that he hasn't got the backup SW's SQL agent - not
the SQL Server Agent.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Tuesday, February 14, 2012
backup
Hi All,
i want backup my SQL server (2005) but i do not have SQL agnet for backup
can i use follow script to copy whole database file and backup this file
with NTBackup? can it's backup be restore and work fine? pls advise.
net stop "SQL Server (MSSMLBIZ)"
xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1" "C:\Backup\BIZ"
/Y
net start "SQL Server (MSSMLBIZ)"
thanks,
Williamyes this should work.
William Cheung wrote:
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1" "C:\Backup\BIZ
"
> /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>|||Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
Standard Edition (which includes SQL Agent.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:%23azj7ViAHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1"
> "C:\Backup\BIZ" /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>|||Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
Standard Edition (which includes SQL Agent.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:%23azj7ViAHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1"
> "C:\Backup\BIZ" /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>|||Arnie Rowland wrote:
> Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
> Standard Edition (which includes SQL Agent.)
>
I think that he means that he hasn't got the backup SW's SQL agent - not
the SQL Server Agent.
Regards
Steen Schlter Persson
Database Administrator / System Administrator
i want backup my SQL server (2005) but i do not have SQL agnet for backup
can i use follow script to copy whole database file and backup this file
with NTBackup? can it's backup be restore and work fine? pls advise.
net stop "SQL Server (MSSMLBIZ)"
xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1" "C:\Backup\BIZ"
/Y
net start "SQL Server (MSSMLBIZ)"
thanks,
Williamyes this should work.
William Cheung wrote:
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1" "C:\Backup\BIZ
"
> /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>|||Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
Standard Edition (which includes SQL Agent.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:%23azj7ViAHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1"
> "C:\Backup\BIZ" /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>|||Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
Standard Edition (which includes SQL Agent.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:%23azj7ViAHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1"
> "C:\Backup\BIZ" /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>|||Arnie Rowland wrote:
> Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
> Standard Edition (which includes SQL Agent.)
>
I think that he means that he hasn't got the backup SW's SQL agent - not
the SQL Server Agent.
Regards
Steen Schlter Persson
Database Administrator / System Administrator
backup
Hi All,
i want backup my SQL server (2005) but i do not have SQL agnet for backup
can i use follow script to copy whole database file and backup this file
with NTBackup? can it's backup be restore and work fine? pls advise.
net stop "SQL Server (MSSMLBIZ)"
xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1" "C:\Backup\BIZ"
/Y
net start "SQL Server (MSSMLBIZ)"
thanks,
William
yes this should work.
William Cheung wrote:
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1" "C:\Backup\BIZ"
> /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>
|||Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
Standard Edition (which includes SQL Agent.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:%23azj7ViAHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1"
> "C:\Backup\BIZ" /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>
|||Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
Standard Edition (which includes SQL Agent.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:%23azj7ViAHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1"
> "C:\Backup\BIZ" /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>
i want backup my SQL server (2005) but i do not have SQL agnet for backup
can i use follow script to copy whole database file and backup this file
with NTBackup? can it's backup be restore and work fine? pls advise.
net stop "SQL Server (MSSMLBIZ)"
xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1" "C:\Backup\BIZ"
/Y
net start "SQL Server (MSSMLBIZ)"
thanks,
William
yes this should work.
William Cheung wrote:
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1" "C:\Backup\BIZ"
> /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>
|||Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
Standard Edition (which includes SQL Agent.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:%23azj7ViAHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1"
> "C:\Backup\BIZ" /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>
|||Why don't you have SQL Agent? (Your other post indicated you had SQL 2005
Standard Edition (which includes SQL Agent.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Cheung" <chun_hei@.msn.com> wrote in message
news:%23azj7ViAHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> i want backup my SQL server (2005) but i do not have SQL agnet for backup
> can i use follow script to copy whole database file and backup this file
> with NTBackup? can it's backup be restore and work fine? pls advise.
> net stop "SQL Server (MSSMLBIZ)"
> xcopy /e /f "C:\Program Files\Microsoft SQL Server\MSSQL.1"
> "C:\Backup\BIZ" /Y
> net start "SQL Server (MSSMLBIZ)"
> thanks,
> William
>
Subscribe to:
Posts (Atom)