Create DB from a backup

Discussion in 'Databases' started by MUVEKA, Feb 25, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Hi,
    I am trying to upload data in my DAP SQL Server 2005 Database account. I am using MS Sql Server management Studio Express. The steps I follow are
    1. Right click on my remote DB
    2. Click on Tasks
    3. Restore Database.

    Unfortunately, I get this error. Can you please help me?


    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
    ------------------------------
    SELECT permission denied on column 'backup_set_id' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_start_date' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'server_name' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'is_copy_only' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_set_id' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_start_date' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'server_name' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_set_id' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_start_date' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'server_name' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_set_id' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_set_uuid' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'media_set_id' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'first_family_number' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'first_media_number' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'last_family_number' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'last_media_number' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'catalog_family_number' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'catalog_media_number' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'position' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'expiration_date' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'software_vendor_id' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'name' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'description' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'user_name' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'software_major_version' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'software_minor_version' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'software_build_version' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'time_zone' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'mtf_minor_version' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'first_lsn' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'last_lsn' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'checkpoint_lsn' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'database_backup_lsn' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'database_creation_date' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_start_date' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'sort_order' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'code_page' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'compatibility_level' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'database_version' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_size' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'server_name' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'machine_name' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'flags' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'unicode_locale' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'unicode_compare_style' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'collation_name' of object 'backupset', database 'msdb', schema 'dbo'. (Microsoft SQL Server, Error: 230)

    Thanks so much!
     
  2. Don't bother to respond to this one, I am now trying to use the SQL Tools attached in the Control Panel.


    Thanks!
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page