DB Restore

HI, I am restoring a DB .BAK file which is around 1.8 GBs. It is taking a lot of time to complete. Is this expected?

Thanks a lot.

It all depends on your hardware components and system configuration.......generally speaking it should not take more than 10 mins for 2 GB backup files..........also check if the backup file is valid by using,

restore verifyonly from disk='path of the backup file'

Also I think you should have posted this in database engine forum as that seems to be more appropriate for your question......

|||

Also, it may be that your data and log files are much larger than 1.8GB and its taking a long time to create these files.

The database backup file will be the size of the actual data stored whereas the files you restore will have the blank pages allocated as well which could make them much larger.

This is quite a common scenario with the transaction log when it can grow quite large over time but is never physically truncated.

HTH!

DB Maintenance Plan Never Fully Completes

Frequently I have a problem where a maintenance plan will
complete, but the job status in EM states that the job is
still running with a status of "Performing Completion
Actions". I am unable to stop the job, and even though
the logs show the job to have completed successfully, the
operator is never sent the report.You could have blocking on sysoperators but it's most likely
related to the mail configuration. Does the mail profile
work correctly for other jobs? If not, you need to look at
your mail configuration. Check:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
Do you have the mail profile setup for Exchange and an
Outlook Address Book service? I've seen that cause similar
issues as it doesn't cleanly handle the situation where the
mail server isn't available. Removing the Address Book
service from the profile usually cleans it up.
You can clean up the hanging job by restarting SQL Agent
service.
-Sue
On Mon, 18 Aug 2003 12:58:32 -0700, "Gary Mercier"
<gmercier@.newgistics.com> wrote:
>Frequently I have a problem where a maintenance plan will
>complete, but the job status in EM states that the job is
>still running with a status of "Performing Completion
>Actions". I am unable to stop the job, and even though
>the logs show the job to have completed successfully, the
>operator is never sent the report.

DB Maintainance Plan

HI
I have shedules a complete backup using DB maintainance plan and checked option to Remove files older than 1 day
Questions - Does file get removed after new backup is done or before the new backup starts
Also, what happens in case DB Consistency check fails in the Integrity tab, does backup still goes through ?
Thanks
Sanjay
The Delete happens after the backup completes. I believe the DBCC is a
separate job altogether but you should confirm this on your system.
Andrew J. Kelly SQL MVP
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:8934B2F8-1980-4FA3-B2AE-D5CDBD7329AE@.microsoft.com...
> HI
> I have shedules a complete backup using DB maintainance plan and checked
option to Remove files older than 1 day
> Questions - Does file get removed after new backup is done or before the
new backup starts
> Also, what happens in case DB Consistency check fails in the Integrity
tab, does backup still goes through ?
> Thanks
> Sanjay
>
>
|||I think the files get removed as the last step... And if DBCC fails from the
previous tab (when it is NOT included in the full db backup), it does not
prevent the backup from occurring...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:8934B2F8-1980-4FA3-B2AE-D5CDBD7329AE@.microsoft.com...
> HI
> I have shedules a complete backup using DB maintainance plan and checked
option to Remove files older than 1 day
> Questions - Does file get removed after new backup is done or before the
new backup starts
> Also, what happens in case DB Consistency check fails in the Integrity
tab, does backup still goes through ?
> Thanks
> Sanjay
>
>
|||I beleive there was a problem with "Attempt to repair minor problems" in Optimization tab in SQL server
Is that still a problem and we shoudnt use it ?
"Wayne Snyder" wrote:

> I think the files get removed as the last step... And if DBCC fails from the
> previous tab (when it is NOT included in the full db backup), it does not
> prevent the backup from occurring...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> news:8934B2F8-1980-4FA3-B2AE-D5CDBD7329AE@.microsoft.com...
> option to Remove files older than 1 day
> new backup starts
> tab, does backup still goes through ?
>
>
|||It was a problem in that it put the database in single user mode and left it
there. You should not have the MP automatically "Fix" the database. If
there is a problem you should determine what is is and what the best coarse
of action is and also determine why there was a problem in the first place.
That option should have been removed a long time ago in my opinion.
Andrew J. Kelly SQL MVP
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:608CE6D4-455A-489E-9AF6-103C853E0A4B@.microsoft.com...
> I beleive there was a problem with "Attempt to repair minor problems" in
Optimization tab in SQL server[vbcol=seagreen]
> Is that still a problem and we shoudnt use it ?
>
> "Wayne Snyder" wrote:
the[vbcol=seagreen]
not[vbcol=seagreen]
checked[vbcol=seagreen]
the[vbcol=seagreen]

DB Maintainance Plan

HI
I have shedules a complete backup using DB maintainance plan and checked opt
ion to Remove files older than 1 day
Questions - Does file get removed after new backup is done or before the new
backup starts
Also, what happens in case DB Consistency check fails in the Integrity tab,
does backup still goes through ?
Thanks
SanjayThe Delete happens after the backup completes. I believe the DBCC is a
separate job altogether but you should confirm this on your system.
Andrew J. Kelly SQL MVP
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:8934B2F8-1980-4FA3-B2AE-D5CDBD7329AE@.microsoft.com...
> HI
> I have shedules a complete backup using DB maintainance plan and checked
option to Remove files older than 1 day
> Questions - Does file get removed after new backup is done or before the
new backup starts
> Also, what happens in case DB Consistency check fails in the Integrity
tab, does backup still goes through ?
> Thanks
> Sanjay
>
>|||I think the files get removed as the last step... And if DBCC fails from the
previous tab (when it is NOT included in the full db backup), it does not
prevent the backup from occurring...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:8934B2F8-1980-4FA3-B2AE-D5CDBD7329AE@.microsoft.com...
> HI
> I have shedules a complete backup using DB maintainance plan and checked
option to Remove files older than 1 day
> Questions - Does file get removed after new backup is done or before the
new backup starts
> Also, what happens in case DB Consistency check fails in the Integrity
tab, does backup still goes through ?
> Thanks
> Sanjay
>
>|||I beleive there was a problem with "Attempt to repair minor problems" in Opt
imization tab in SQL server
Is that still a problem and we shoudnt use it ?
"Wayne Snyder" wrote:

> I think the files get removed as the last step... And if DBCC fails from t
he
> previous tab (when it is NOT included in the full db backup), it does not
> prevent the backup from occurring...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> news:8934B2F8-1980-4FA3-B2AE-D5CDBD7329AE@.microsoft.com...
> option to Remove files older than 1 day
> new backup starts
> tab, does backup still goes through ?
>
>|||It was a problem in that it put the database in single user mode and left it
there. You should not have the MP automatically "Fix" the database. If
there is a problem you should determine what is is and what the best coarse
of action is and also determine why there was a problem in the first place.
That option should have been removed a long time ago in my opinion.
Andrew J. Kelly SQL MVP
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:608CE6D4-455A-489E-9AF6-103C853E0A4B@.microsoft.com...
> I beleive there was a problem with "Attempt to repair minor problems" in
Optimization tab in SQL server[vbcol=seagreen]
> Is that still a problem and we shoudnt use it ?
>
> "Wayne Snyder" wrote:
>
the[vbcol=seagreen]
not[vbcol=seagreen]
checked[vbcol=seagreen]
the[vbcol=seagreen]