Solved

Restore VIEWs to a new server?

Posted on 2014-09-15
2
219 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
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

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.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

815 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now