backing up

we want to back up our new point of sale system with is
running a sequel server. on to a zip drive software does
not come with any instructions for how to do so any ideas?
Personally, I would probably try to backup to disk first, and then =
backup to your removable drive.
Either way, something like this should work for you, just change the =
drive letter.
Test this from Query Analyzer. When it works create a scheduled job. =
You will also want to backup msdb as well as your user database(s). =
Make sure that you backup each database to a separate file.
BACKUP DATABASE master TO DISK =3D 'c:\master.bak' WITH INIT
go
EXEC master..xp_cmdshell 'copy c:\master.bak x:\master.bak'
GO
--=20
Keith
"chris" <anonymous@.discussions.microsoft.com> wrote in message =
news:b80c01c43791$fc4f2f50$a001280a@.phx.gbl...
> we want to back up our new point of sale system with is=20
> running a sequel server. on to a zip drive software does=20
> not come with any instructions for how to do so any ideas?

backing up

we want to back up our new point of sale system with is
running a sequel server. on to a zip drive software does
not come with any instructions for how to do so any ideas?Personally, I would probably try to backup to disk first, and then =
backup to your removable drive.
Either way, something like this should work for you, just change the =
drive letter.
Test this from Query Analyzer. When it works create a scheduled job. =
You will also want to backup msdb as well as your user database(s). =
Make sure that you backup each database to a separate file.
BACKUP DATABASE master TO DISK =3D 'c:\master.bak' WITH INIT
go
EXEC master..xp_cmdshell 'copy c:\master.bak x:\master.bak'
GO
--=20
Keith
"chris" <anonymous@.discussions.microsoft.com> wrote in message =
news:b80c01c43791$fc4f2f50$a001280a@.phx.gbl...
> we want to back up our new point of sale system with is=20
> running a sequel server. on to a zip drive software does=20
> not come with any instructions for how to do so any ideas?

backing up

we want to back up our new point of sale system with is
running a sequel server. on to a zip drive software does
not come with any instructions for how to do so any ideas?Personally, I would probably try to backup to disk first, and then =backup to your removable drive.
Either way, something like this should work for you, just change the =drive letter.
Test this from Query Analyzer. When it works create a scheduled job. =You will also want to backup msdb as well as your user database(s). =Make sure that you backup each database to a separate file.
BACKUP DATABASE master TO DISK =3D 'c:\master.bak' WITH INIT
go
EXEC master..xp_cmdshell 'copy c:\master.bak x:\master.bak'
GO
-- Keith
"chris" <anonymous@.discussions.microsoft.com> wrote in message =news:b80c01c43791$fc4f2f50$a001280a@.phx.gbl...
> we want to back up our new point of sale system with is > running a sequel server. on to a zip drive software does > not come with any instructions for how to do so any ideas?