backup views?

Hi,
I have in one database about 300 views. I have just backed up this database
and restored it with a different name. I have to drop all views from the
first database and the plan is to use the backed up database to restore the
views. How do I do this? If I use DTS, will data be ovewritten from the 2nd
database to the first one?
thanks,
aolxpHi,
You can not restore only the view from the database backup.
View will not hold any data until or unless u are using Indexed view. So you
can very well overwrite the view. Even if it is table in DTS
you have option to Overwrite or Append to existing table.
Thanks
Hari
SQL Server MVP
"aolxp" <sa@.anonymous.com> wrote in message
news:%23RBtmeJRFHA.3076@.tk2msftngp13.phx.gbl...
> Hi,
> I have in one database about 300 views. I have just backed up this
> database and restored it with a different name. I have to drop all views
> from the first database and the plan is to use the backed up database to
> restore the views. How do I do this? If I use DTS, will data be ovewritten
> from the 2nd database to the first one?
> thanks,
> aolxp
>|||Thanks Hari. I will actually delete all the views from the 1st database and
then use the second db to DTS them. No indexed views.
will it be allright?
aolxp
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:O9K4fiJRFHA.2744@.TK2MSFTNGP10.phx.gbl...
> Hi,
> You can not restore only the view from the database backup.
> View will not hold any data until or unless u are using Indexed view. So
> you can very well overwrite the view. Even if it is table in DTS
> you have option to Overwrite or Append to existing table.
> Thanks
> Hari
> SQL Server MVP
> "aolxp" <sa@.anonymous.com> wrote in message
> news:%23RBtmeJRFHA.3076@.tk2msftngp13.phx.gbl...
>> Hi,
>> I have in one database about 300 views. I have just backed up this
>> database and restored it with a different name. I have to drop all views
>> from the first database and the plan is to use the backed up database to
>> restore the views. How do I do this? If I use DTS, will data be
>> ovewritten from the 2nd database to the first one?
>> thanks,
>> aolxp
>|||Hi,
Yes, You can do that.
But best approach is script the views using Enterprise manager from 2nd
database and open query analyzer and execute in first database.
Thanks
Hari
SQL Server MVP
"aolxp" <sa@.anonymous.com> wrote in message
news:uS6kBlJRFHA.2604@.TK2MSFTNGP10.phx.gbl...
> Thanks Hari. I will actually delete all the views from the 1st database
> and then use the second db to DTS them. No indexed views.
> will it be allright?
> aolxp
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:O9K4fiJRFHA.2744@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> You can not restore only the view from the database backup.
>> View will not hold any data until or unless u are using Indexed view. So
>> you can very well overwrite the view. Even if it is table in DTS
>> you have option to Overwrite or Append to existing table.
>> Thanks
>> Hari
>> SQL Server MVP
>> "aolxp" <sa@.anonymous.com> wrote in message
>> news:%23RBtmeJRFHA.3076@.tk2msftngp13.phx.gbl...
>> Hi,
>> I have in one database about 300 views. I have just backed up this
>> database and restored it with a different name. I have to drop all views
>> from the first database and the plan is to use the backed up database to
>> restore the views. How do I do this? If I use DTS, will data be
>> ovewritten from the 2nd database to the first one?
>> thanks,
>> aolxp
>>
>