Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Taking database offline each night for a backup
Message
From
18/03/2006 17:52:49
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
 
General information
Forum:
Microsoft SQL Server
Category:
Backups
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01105541
Message ID:
01105601
Views:
18
Not sure what you mean by a full backup?

You need to make sure you backup the user database your interested in and also Master (holds all information regarding users, security and loads more), MSDB (holds any jobs, alerts DTS packages) and Model (the template database for all other database). Backing up these system database will ensure that you can restore the server correctly if anything goes wrong.

Regards

Jon
>>You don't need to shutdown the server to backup - just set up a backup schedule using EM ?
>
>That isn't a complete backup though, correct?
Previous
Reply
Map
View

Click here to load this message in the networking platform