Hi all,
Just a quick question. I've searched through the docs for this but am still
not certain. Can you tell me if, during a Maintenance Plan's backup
procedure, the database is still available or does the MP put it into
Single-User Mode / Offline?
Cheers,
IMAs in all backups, the database is available to all users.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
news:E1C32915-5794-45BF-BE2F-513937DBCD1A@.microsoft.com...
Hi all,
Just a quick question. I've searched through the docs for this but am still
not certain. Can you tell me if, during a Maintenance Plan's backup
procedure, the database is still available or does the MP put it into
Single-User Mode / Offline?
Cheers,
IM|||Many thanks Tom. That's what I thought but it's good to know for sure.
Cheers,
IM
"Tom Moreau" wrote:
> As in all backups, the database is available to all users.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
> news:E1C32915-5794-45BF-BE2F-513937DBCD1A@.microsoft.com...
> Hi all,
> Just a quick question. I've searched through the docs for this but am still
> not certain. Can you tell me if, during a Maintenance Plan's backup
> procedure, the database is still available or does the MP put it into
> Single-User Mode / Offline?
> Cheers,
> IM
>|||This is a multi-part message in MIME format.
--010201060107060106030405
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
This is true but there are a few file management type operations that
cannot run while a backup is in progress:
* ALTER DATABASE (with ADD FILE or REMOVE FILE)
* DBCC SHRINKDATABASE
* DBCC SHRINKFILE
A backup won't start while these are in progress and you can't start one
of these operations while a backup is in progress.
--
*mike hodgson*
/ mallesons stephen jaques/
blog: http://sqlnerd.blogspot.com
Tom Moreau wrote:
>As in all backups, the database is available to all users.
>
>
--010201060107060106030405
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>This is true but there are a few file management type operations
that cannot run while a backup is in progress:<br>
</tt>
<ul>
<li><tt>ALTER DATABASE (with ADD FILE or REMOVE FILE)</tt></li>
<li><tt>DBCC SHRINKDATABASE</tt></li>
<li><tt>DBCC SHRINKFILE</tt></li>
</ul>
<tt>A backup won't start while these are in progress and you can't
start one of these operations while a backup is in progress.<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<em><font face="Tahoma" size="2"> mallesons</font><font face="Tahoma"> </font><font
face="Tahoma" size="2">stephen</font><font face="Tahoma"> </font><font
face="Tahoma" size="2"> jaques</font></em><font face="Tahoma"><br>
</font><font face="Tahoma" size="2">blog:</font><font face="Tahoma"
size="2"> <a href="http://links.10026.com/?link=/">http://sqlnerd.blogspot.com">
http://sqlnerd.blogspot.com</a></font></span> </p>
</div>
<br>
<br>
Tom Moreau wrote:
<blockquote cite="miduOjdsJ%23dFHA.1136@.TK2MSFTNGP12.phx.gbl"
type="cite">
<pre wrap="">As in all backups, the database is available to all users.
</pre>
</blockquote>
</body>
</html>
--010201060107060106030405--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment