DB Restore from multiple files

Hi,
I've got a pretty large database that i normally backup to 6 files and
restore it to another database. I've only done this through enterprise
manager so it's just point and click. But i was wondering if anyone knew what
the command line version of this would be? Would you use "stripe" ? Trying to
script the backup and restore part. Any help would be greatly appreciated.
-FS
Hello,
See RESTORE DATABASE command in books online. Use the below sample.
RESTORE DATABASE DBNAME FROM disk = 'C:\MSSQL\BACKUP\DBA_db_BKUP_BAK1.BAK',
disk = 'D:\MSSQL\MSSQL\BACKUP\DBA_db_BKUP_BAK2.BAK',disk =
'E:\MSSQL\MSSQL\BACKUP\DBA_db_BKUP_BAK3.BAK', Stats=1
Thanks
Hari
"FS" <FS@.discussions.microsoft.com> wrote in message
news:28DD5BE8-5B09-4262-81FE-B3C6CA5FB636@.microsoft.com...
> Hi,
> I've got a pretty large database that i normally backup to 6 files and
> restore it to another database. I've only done this through enterprise
> manager so it's just point and click. But i was wondering if anyone knew
> what
> the command line version of this would be? Would you use "stripe" ? Trying
> to
> script the backup and restore part. Any help would be greatly appreciated.
> -FS

DB Restore from multiple files

Hi,
I've got a pretty large database that i normally backup to 6 files and
restore it to another database. I've only done this through enterprise
manager so it's just point and click. But i was wondering if anyone knew wha
t
the command line version of this would be? Would you use "stripe" ? Trying t
o
script the backup and restore part. Any help would be greatly appreciated.
-FSHello,
See RESTORE DATABASE command in books online. Use the below sample.
RESTORE DATABASE DBNAME FROM disk = 'C:\MSSQL\BACKUP\DBA_db_BKUP_BAK1.BAK',
disk = 'D:\MSSQL\MSSQL\BACKUP\DBA_db_BKUP_BAK2.BAK',disk =
'E:\MSSQL\MSSQL\BACKUP\DBA_db_BKUP_BAK3.BAK', Stats=1
Thanks
Hari
"FS" <FS@.discussions.microsoft.com> wrote in message
news:28DD5BE8-5B09-4262-81FE-B3C6CA5FB636@.microsoft.com...
> Hi,
> I've got a pretty large database that i normally backup to 6 files and
> restore it to another database. I've only done this through enterprise
> manager so it's just point and click. But i was wondering if anyone knew
> what
> the command line version of this would be? Would you use "stripe" ? Trying
> to
> script the backup and restore part. Any help would be greatly appreciated.
> -FS

DB Restore from multiple files

Hi,
I've got a pretty large database that i normally backup to 6 files and
restore it to another database. I've only done this through enterprise
manager so it's just point and click. But i was wondering if anyone knew what
the command line version of this would be? Would you use "stripe" ? Trying to
script the backup and restore part. Any help would be greatly appreciated.
-FSHello,
See RESTORE DATABASE command in books online. Use the below sample.
RESTORE DATABASE DBNAME FROM disk = 'C:\MSSQL\BACKUP\DBA_db_BKUP_BAK1.BAK',
disk = 'D:\MSSQL\MSSQL\BACKUP\DBA_db_BKUP_BAK2.BAK',disk ='E:\MSSQL\MSSQL\BACKUP\DBA_db_BKUP_BAK3.BAK', Stats=1
Thanks
Hari
"FS" <FS@.discussions.microsoft.com> wrote in message
news:28DD5BE8-5B09-4262-81FE-B3C6CA5FB636@.microsoft.com...
> Hi,
> I've got a pretty large database that i normally backup to 6 files and
> restore it to another database. I've only done this through enterprise
> manager so it's just point and click. But i was wondering if anyone knew
> what
> the command line version of this would be? Would you use "stripe" ? Trying
> to
> script the backup and restore part. Any help would be greatly appreciated.
> -FS

DB Maintenance/Optimizations

When setting up a DB Maintenance plan, what do users
normally do with the options in the Optimizations tab?
Does it matter what application is using the database?
(In this case, it is Microsoft Business Solutions-
Solomon.) Thanks.It matters if the application is 24 x 7. The optimization routines for the
MP use DBCC DBREINDEX and that will take your table off line for the
duration of the reindexing. If you have a maintenance window for this then
it may not be a problem. I usually suggest creating your own scheduled
jobs that do exactly what you need done and when instead of using the MP.
--
Andrew J. Kelly
SQL Server MVP
"Roger" <anonymous@.discussions.microsoft.com> wrote in message
news:05ca01c3cef5$e589f980$a001280a@.phx.gbl...
> When setting up a DB Maintenance plan, what do users
> normally do with the options in the Optimizations tab?
> Does it matter what application is using the database?
> (In this case, it is Microsoft Business Solutions-
> Solomon.) Thanks.|||Is that Maintenance Wizard an inside joke?
Seems to me it's a great way for less-knowledgeable 'dba's' to get bollixed
up.
Other than that, it's like your appendix - it's there but it serves no
useful purpose.
James Hokes
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23fn3IwxzDHA.3900@.tk2msftngp13.phx.gbl...
> It matters if the application is 24 x 7. The optimization routines for
the
> MP use DBCC DBREINDEX and that will take your table off line for the
> duration of the reindexing. If you have a maintenance window for this
then
> it may not be a problem. I usually suggest creating your own scheduled
> jobs that do exactly what you need done and when instead of using the MP.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Roger" <anonymous@.discussions.microsoft.com> wrote in message
> news:05ca01c3cef5$e589f980$a001280a@.phx.gbl...
> > When setting up a DB Maintenance plan, what do users
> > normally do with the options in the Optimizations tab?
> > Does it matter what application is using the database?
> > (In this case, it is Microsoft Business Solutions-
> > Solomon.) Thanks.
>|||That's what I think the biggest problem of using the Maintenance Wizard is.
When someone new to sqls erver uses the wizard to get going they have no
knowledge of what is actually happening. So if something does go wrong they
are not in a good position to fix it. If they took a few minutes to learn
how to create their own job to do the task they are much more likely to have
a better handle on things overall.
--
Andrew J. Kelly
SQL Server MVP
"James Hokes" <noemail@.noway.com> wrote in message
news:eUkRxb1zDHA.2872@.TK2MSFTNGP09.phx.gbl...
> Is that Maintenance Wizard an inside joke?
> Seems to me it's a great way for less-knowledgeable 'dba's' to get
bollixed
> up.
> Other than that, it's like your appendix - it's there but it serves no
> useful purpose.
> James Hokes
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23fn3IwxzDHA.3900@.tk2msftngp13.phx.gbl...
> > It matters if the application is 24 x 7. The optimization routines for
> the
> > MP use DBCC DBREINDEX and that will take your table off line for the
> > duration of the reindexing. If you have a maintenance window for this
> then
> > it may not be a problem. I usually suggest creating your own scheduled
> > jobs that do exactly what you need done and when instead of using the
MP.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Roger" <anonymous@.discussions.microsoft.com> wrote in message
> > news:05ca01c3cef5$e589f980$a001280a@.phx.gbl...
> > > When setting up a DB Maintenance plan, what do users
> > > normally do with the options in the Optimizations tab?
> > > Does it matter what application is using the database?
> > > (In this case, it is Microsoft Business Solutions-
> > > Solomon.) Thanks.
> >
> >
>