| Author |
SQL Views.. Backup And Restore..
|
|
| AshVsAOD 2005-04-25, 8:23 pm |
| What is the best way to backup and restore only the Views in a Database?
Thanks
| |
| Andrew J. Kelly 2005-04-26, 3:23 am |
| Well you can't actually backup and restore them but you can script their
definitions and always rebuild them if needed. You can use DMO to script
them programmatically or simply use EM to manually do it.
--
Andrew J. Kelly SQL MVP
"AshVsAOD" <.> wrote in message
news:eKUHfLfSFHA.1348@TK2MSFTNGP15.phx.gbl...
> What is the best way to backup and restore only the Views in a Database?
>
> Thanks
>
>
| |
| AshVsAOD 2005-04-26, 3:23 am |
| The issue I have with scripting is that it doesnt map out dependencies which
is insane.
Thanks anyway.
"Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
news:#aLjgMgSFHA.580@TK2MSFTNGP15.phx.gbl...
> Well you can't actually backup and restore them but you can script their
> definitions and always rebuild them if needed. You can use DMO to script
> them programmatically or simply use EM to manually do it.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "AshVsAOD" <.> wrote in message
> news:eKUHfLfSFHA.1348@TK2MSFTNGP15.phx.gbl...
>
>
|
|
|
|