Showing posts with label writer. Show all posts
Showing posts with label writer. Show all posts

Tuesday, March 27, 2012

Backup SQL using MSDE Writer

How do I backup my SQL Databases using MSDE Writers?

I do not see MSDE Writers under NT Backup.

Thanks

Santhosh

You also don't see any of the other writers. They generally aren't directly used by a backup user.

The backup app may use them behind the scenes. The important thing is whether the backup app correctly backs up your SQL database. If you back up a volume containing a SQL database, the MSDE writer should be invoked behind the scenes automatically as part of the VSS snapshot done by NTBackup.

Thursday, March 8, 2012

backup operator

I need to give a group the role of db_backup operator. do they need anything else like db_datareader or writer? I'm not sure what they will be able to do other than backup? I've never given anyone this role.
ThanksThis is SQL forum (language, not database). Your question seems to be database-dependant, so you'd perhaps better ask it in forum which covers the database you use (is it MS SQL Server, DB2, ...?).