|
Home > Archive > MS SQL Server Tools > November 2006 > backup
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]
|
|
| William Cheung 2006-11-07, 7:14 pm |
| 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
>
>
| |
| Arnie Rowland 2006-11-07, 7:14 pm |
| 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 2006-11-07, 7:14 pm |
| 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
|
|
|
|
|