how I Backing Up SQL Server database? I am new to SQL Server Admin and am hoping to get some help? I have a database that only contains views of data from another database. It has no tables at all.
Is there a way to backup the data in the views?
Thanks in advance.
Once you have taken steps to backup the other database that contains the real data, you could also backup the views from your views only database, by scripting them out using SQL Server Management Studio

From SQL Server Management Studio
Via Object Explorer


Expand the database you wish to backup views for
Right click on the database and select Tasks -> Generate Scripts
Choose "Select specific database objects"
Check views or just the views you want to backup





Select Next
Choose Save to new query window





Choose next and then next again
Click on finish and the view or views you selected will be scripted to a new window