0

Im trying to run DTS from one Db to another in Same server instance. But at the select objects to copy stage, its showing the VIEWs also. But VIEWS are only some customised queries. But why its been shows in DTS

Sandeep Thomas
  • 141
  • 6

2 Answers2

3

Either use the SSMS Copy Database Wizard

Or use the SSMS Backup Database UI to backup and restore to the instance's default backup location.

David Browne - Microsoft
  • 49,000
  • 3
  • 53
  • 102
0

If you are one of the dbas, and you need to back up databases, you need access to some storage. If the system/network admins won't give you that, you have your manager go to theirs and get it resolved. I smell a rat.

Also, to answer the question of why views are showing, it's because SQL Server shows views as if they were tables. You'll see tables and views when connecting to the database using most means. I am thankful for this, because it means my business analysts can tell me how they want the data to look, and I tell them the name of the dataset (view) they want to consume.

J.D. Walker
  • 157
  • 6