Freezing Database or Server
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Date: Fri, 20 Feb 2004 11:01:08 -0800
In Oracle there a way to 'freeze' a tablespace when doing a backup. Does SQL Server have a way to 'freeze' the tables or the database?
Relevant Pages
- RE: Backups have Shadow Copy Problems
... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
(microsoft.public.windows.server.sbs) - Re: Oracle licence question
... And no - it does not freeze anything, the backups DO NOT affect connections ... SQL Server MVP ... freeze the database and send it to the target. ... What I really wanted is something that lists features I get in Oracle ...
(comp.databases.oracle.server) - Re: Im using sys.master_files.
... This I carried out within the Microsoft SQL Server Management Studio when creating or editing a Maintenance Plan. ... Previously I received the error when trying to undertake a differentail backup without a full backup existing. ... However with the differential backup having a changed extension it happily takes the backup! ... current database backup does not exist. ...
(microsoft.public.sqlserver.server) - Re: Start SQLServerAgent job Synchronously
... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
(microsoft.public.sqlserver.server) - Re: Start SQLServerAgent job Synchronously
... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
(microsoft.public.sqlserver.programming) |
|
