Solved

Restore VIEWs to a new server?

Posted on 2014-09-15
2
235 Views
Last Modified: 2014-09-16
We have a SQL Server 2000, it has a database that we will restore to SQL Server 2008 R2.
We have created a couple of VIEWs against some tables in this database.

I am wondering after I restore the database to SQL Server 2008 R2, will the VIEWs be also restored? If not, how can I make the VIEWs showing up in SQL Server 2008 R2 without re-creating them manually?

Thanks in advance!
0
Comment
Question by:techcity
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 13

Accepted Solution

by:
Russell Fox earned 500 total points
ID: 40324086
The views are database objects, so they should also restore. You should test them, however, just in case something has broken between 2000 and 2008.
0
 
LVL 1

Author Closing Comment

by:techcity
ID: 40326273
Yes, I saw the views after restoration!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Remove () 10 42
VM SQL server license. 1 67
Datatable / Dates ? 4 33
Its possible to connect an Access ADP project to SQL Express 2016? 5 18
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question