Not sure if this really if the right forum but i have a question about MSDE.
When backing it up do you generally need a database agent for the backup
software?
more specifically, if you are backing up a server, with MSDE databases,
using Tivoli Storage Managers do you need the Databases module? (the databas
e
module specifically mentions only SQL)Hi
If you want to schedule your backup database , so yes you need SQL Server
Agent
"Michlong" <Michlong@.discussions.microsoft.com> wrote in message
news:6E737ABC-6596-4996-8312-46FBAF516E75@.microsoft.com...
> Not sure if this really if the right forum but i have a question about
> MSDE.
> When backing it up do you generally need a database agent for the backup
> software?
> more specifically, if you are backing up a server, with MSDE databases,
> using Tivoli Storage Managers do you need the Databases module? (the
> database
> module specifically mentions only SQL)|||You don't absolutely need a database backup agent for MSDE. You can use
the native BACKUP command or, if you can afford to take the database
offline during backup, you can just backup the database files from the
filesystem.
The advantage of using the Tivoli Data Protection module is that it
allows integration with the Tivoli storage management software.
I really don't know whether Tivoli supports MSDE, I've only used it
with SQL Server Enterprise, you'll have to check with IBM or your
vendor.
David Portas
SQL Server MVP
--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment