|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > Backup DB
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Sanjay 2002-08-14, 12:23 pm |
| We r in sql 7.0 and db is in simple recovery mode
When database is being backed up its not allowing be to
create indexes, do bulk load and a lot other things
Eaxactly what r the comands prohibited when backup is
running
Is this limitation there in SQL 2000 too
sanjay
| |
| Tom Moreau 2002-08-14, 12:23 pm |
| From the SQL Server 7.0 BOL:
SQL Server uses online backup to allow a database backup while the database is still in use. However, here are some operations that are not allowed during a database or transaction log backup:
a.. File management operations such as the ALTER DATABASE statement with either the ADD FILE or REMOVE FILE options; INSERT, UPDATE, or DELETE statements are allowed during a backup operation.
b.. Shrink database or shrink file. This includes autoshrink operations.
c.. CREATE INDEX. This restriction applies to database backup, not log backup.
d.. Nonlogged operations such as bulk load, SELECT INTO, WRITETEXT, and UPDATETEXT. The database option select into/bulkcopy must be enabled for these operations to be nonlogged.
From the BOL for SQL Server 2000:
SQL Server uses an online backup process to allow a database backup while the database is still in use. The following list includes operations that cannot run during a database or transaction log backup:
a.. File management operations such as the ALTER DATABASE statement with either the ADD FILE or REMOVE FILE options; INSERT, UPDATE, or DELETE statements are allowed during a backup operation.
b.. Shrink database or shrink file. This includes autoshrink operations.
--
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
www.apress.com
"Sanjay" <sanjayg@hotmail.com> wrote in message news:34ee01c243bb$e73e4b80$9ae
62ecf@tkmsftngxa02...
We r in sql 7.0 and db is in simple recovery mode
When database is being backed up its not allowing be to
create indexes, do bulk load and a lot other things
Eaxactly what r the comands prohibited when backup is
running
Is this limitation there in SQL 2000 too
sanjay
| |
| Dinesh.T.K. 2002-08-14, 1:23 pm |
| Sanjay,
Its well documented in BooksOnLine.
Dinesh
--
--
SQL Server FAQ at
www.tkdinesh.com
"Sanjay" <sanjayg@hotmail.com> wrote in message
news:34ee01c243bb$e73e4b80$9ae
62ecf@tkmsftngxa02...
> We r in sql 7.0 and db is in simple recovery mode
>
> When database is being backed up its not allowing be to
> create indexes, do bulk load and a lot other things
>
> Eaxactly what r the comands prohibited when backup is
> running
>
> Is this limitation there in SQL 2000 too
>
> sanjay
|
|
|
|
|