Trouble With Encryption Key - Have Had To Restore Backup Several Times
Feb 7, 2008
Hello all - I have an installation of SQL Server 2K5 Express with Reporting Services on an XP Pro SP2 PC. It has been running for about 6 months now. Within the 1st month, I had to restore the Encryption Key (the Report Manager failed to function properly).
All had been well until last week, when I had to restore the encryption key (for the same reason). After restoring the encryption key, the Report Manager immediately started to work again.
It happened again today, so I had to once again restore the encryption key. Can anyone offer any ideas as to why/how this would happen?
Thanks!
View 3 Replies
ADVERTISEMENT
Jan 16, 2006
Hello!
I started Configure Report Server (2005) and have executed backup of the encryption key.
Problem occurred on restore of the encryption key as following error (I have provided correct backup snk):
ReportServicesConfigUI.WMIProvider.WMIProviderException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.8.39'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.RestoreEncryptionKey(Byte[] encryptedBytes, String password)
ReportingServer sites stop working with similar error (browsing by IE):
The found version is 'C.0.8.39'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)
ReportingServer services are all locked by this.
Can you please tell how to resolve this problem?
Thank you very much!
vbrada
View 6 Replies
View Related
Oct 29, 2015
While migrating Report services in SQL Server 2005 to 2014, I am trying to restore the Encryption Key in RS Configuration Manager in2014. But I cannot click the 'Restore' button in RS Configuration Manager. So if I should be grant more right to do so or any other action?
View 2 Replies
View Related
May 20, 2015
I understand that the disk I/O is the main performance bottleneck however if I increased available RAM would this improve database restore times?
View 5 Replies
View Related
Mar 14, 2006
Hi
Can anyone help?
I have a database using encryption with symmetric keys created using asymmetric keys.
I backed up this database and restored it on another machine along with the service master key.
I can read the encrypted data fine. But all the encrypted stored procs that are associated with the application that uses the data cannot read the data, they just return Nulls.
If I regenerate all the encrypted stored procs from script they work fine again.
Is there a way to restore the database without having to regenerate all the encrypted procs??
View 19 Replies
View Related
Jun 25, 2015
I am looking for a SQL Backup/Restore tools which can restore multiple environments. Here is high level requirements.
1. We have 4 DBs, range from 1 TB - 1.5 TB Each Database. When we restore to QA, DEV, or Staging, we usually restore 4 of them.
2. I am looking for the speed to complete restoring between 1 - 2 hours for 4 DBs.
I am evaluating the Dephix Software but the setup is very complex and its given us a lot of issues with Windows Authentions, and failure in the middle of the backup. I used Guess Software many years ago but can't find it on the web site any more. Speed is very important for us mean complete restoring as fast as possible. We are on SQL 2012 and SQL 2008 R2.We are currently using NETAPP Technology and I have Redgate Backup Tool but I am mainly looking for fast Restore Process.
View 4 Replies
View Related
Feb 5, 2007
Hi all,
Currently we take full database backups nightly for our SQL Server 2000 data warehouse systems. The backups take a very long time over 20 hours and we would like to find a good way to reduce these backup times. How can I change our backup plan to reduce the long backup run times. Data size is 1 TB for our data warehouse database server.
Thanks
View 3 Replies
View Related
Nov 21, 2014
Any simple summary of the new backup encryption? I've found a small handful of articles, but apparently I have some sort of mental block where keys and certs are involved.I'm trying to determine if this is a viable replacement (for our purposes) for SQL Backup, which we started using primarily for the compression and encryption. We don't have issues with SQL Backup, I'd rather not install additional utilities for native functionality.
What I can't seem to understand is how one goes about restoring an encrypted backup onto another server. When one restores the master key onto the destination server, what happens to the existing key on that server?
Right now, we have backups off-site in third-party storage, and all we need to restore is the .sqb and the password (and the SQB converter). With native encryption, we need the .bak, the keys, the cert, and the password?
View 3 Replies
View Related
Oct 27, 2015
I've got the below and have several variation and still cant seem to find a perfect way to query the server to bring back that last full backup per db. I'm shopwing mutilple records in the backup set db w/ type = 'D'. I look online and type D = Database. Which i assumed it meant full database backup. Apparently not. Try running the below on one of your full databases. Then check to see if the date is actually the last backup date.
DECLARE @db_name VARCHAR(100)
SELECT @db_name = DB_NAME()
-- Get Backup History for required database
SELECT TOP ( 30 ) s.database_name,
m.physical_device_name,
[Code] ....
View 9 Replies
View Related
Jun 7, 2007
Hi,
I want to backup my database at regular intervals and encrypt it. Also I want to verify the back up. How do I do it?
I want the back ups to run every fortnight.
Thanks.
View 1 Replies
View Related
Aug 3, 2015
Need to restore database,here's the scenario:
Data got deleted on Friday evening, need to have database restored to FRiday afternoon and also some data has been entered on Monday, which needs to be there.
View 8 Replies
View Related
Oct 29, 2007
Is there a way to schedule the backup of encryption keys periodically?
Thanks
Karthika
View 1 Replies
View Related
Mar 11, 2008
I'm trying to backup the Encryption Key for the Reporting Services. After I insert the password / location key file and click Ok, I get the following error:
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070A91
---> System.Runtime.InteropServices.COMException (0x80070A91): Password doesn't meet the requirements of the filter dll's
(Exception from HRESULT: 0x80070A91)
--- End of inner exception stack trace ---
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I have tried with diferents passwords but none of them is ok. I don't have any rule on local windows password policy!
Any suggestions?
Thanks!
MD.
View 8 Replies
View Related
Apr 1, 2008
I should restore a SQL Server 2005 Database from backup. The backup contains three files, named user.bak0, user.bak1 and user.bak2.
How is the syntax of the restore filelistonly and the restore database ... ?
I usualy write
restore filelistonly from disk = 'path and filenam.bak'
restore database. zy
from disk = 'path and filename.bak'
with replace,
move.....
move....
This works but I cannot use it with a splitted backup file. The files are much too big to put together to one file.
Thanks in advance for any help.
View 3 Replies
View Related
Oct 17, 2006
I have a full backup and several diff backup,now i want to restore
firstly,I restore full backup
RESTORE DATABASE ***
FROM DISK = 'D:databackup200610140000.bak'
WITH NORECOVERY
GO
it's working,then i don;'t know how to continue
Thanks in advance
View 3 Replies
View Related
Jan 23, 2008
I just installed Reporting Services (2005) in a "distributed installation" mode. That is, I have sql server 2005 on a separate server. I installed the Report Server on its own server where I already had IIS running.
That all seemed to go well and I didn't get any errors or anything. After the install process was done, I ran the RS Configuration Manager tool. Since "Install but do not configure" option was automatically selected for me, I started working through all the pages from top to bottom. Again everything worked, and I have green checkboxes next to all of the nodes in the left except...
When I get to the Encryption Keys page, it has a blue exclamation icon next to its icon in the left pane. On the page itself, the Backup and Change buttons are disabled, greyed out.
And, the next item down, Initialization, is shown with a greyed out "x" icon. It's not red, but greyed out.
So, I'm not sure what this all means, but I'm guess it means that I don't have RS set up yet...! Any help would be greatly appreciated.
-- M Noreen
View 3 Replies
View Related
Jul 31, 2015
Current am using the below script it is working fine i need use ENCRYPTION script where i should add this
NOREWIND, NOUNLOAD, COMPRESSION,
ENCRYPTION(ALGORITHM = AES_256,
SERVER CERTIFICATE = [BackupCertificate]), STATS = 10
USE [master]
GO
[code]...
View 3 Replies
View Related
Oct 14, 2007
I neglected to backup the transaction log as part of the process of backing up the database. Now i only have the backup file for the database and no transaction log backup. When i try to do a restore on the database, i get the error on a "tail log missing" message (which i'm assuming is that it's looking for the t-log backup?).
Is it possible to restore or even restore to a new database? I'm only looking to retreive data from 2 tables within the backup file.
Thanks!
SQL Server 2005 on Windows 2003 Server x64.
View 16 Replies
View Related
Aug 7, 1998
This seems to happen just after our backups run. the result is that the SQL Server
Enterprise Manager can be brought up the next day but nothing can be accessed or
inquired of. The service is still running, the server is still up and rebooting the server
resolves the problem.
98/08/06 20:32:31.68 kernel dpdb_asyncread: mirror: Operating system error 6
(The handle is invalid.) encountered
Is anybody else using Arcserve Backup Agent for SQL Server for Windows NT, RAID 5?
Have you seen this? I`ve been to MS home page and on technet. No mention of this
problem. Next stop is Arcserve home page, if they have one. I have read the error logs
and this is the second time this has happened this week. Both times since we added
Arcserve to manage our MS SQL Server Database backups.
Best Regards and Thanks for your time.
View 1 Replies
View Related
May 17, 2006
I had to replace my hard drive which was going bad. I reinstalled Sql 2005 and now need to restore the backup that I have. I selected Restore Database and chose From Device, and selected the backup location on J: drive and selected the backup file which has no extenstion. I checked the checkbox next to the backup set to restore. Click OK and then I get this error message:
Restore failed for Server
System.Data.SqlClient.SqlError: Directory lookup for the file "C:Program FilesMicrosoft SQL ServerMSSQLdataMyDB_Data.MDF" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Smo)
I don't know why it is looking for a MDF file as this was never in the Backup folder. Can someone please help me on this? I thought I was doing the right thing making a backup all along and now I can't restore it!
View 2 Replies
View Related
Dec 17, 2001
Is it possisable to restore from tape when the backup was taken from a
different server. ServerA has the tape drive which performs the backups
to tape, but ServerB which is under a different domain wants to restore ServerA database on ServerB, both databases on the two servers are the same
is it possiable to restore a database on ServerB using ServerA file?
View 2 Replies
View Related
May 7, 2001
hello all !!
I suffered a crash on one of my disks on a server runing MS-sql 7.0,and found out my backupexec dosnt really restore a runing version of my database.
which solution would you recomend ,taking in acount i may have a copy of the database on another computer,which files i can restore?
thanks
yochai lam
View 2 Replies
View Related
May 24, 2001
Hi I am operating my databases under "trunc log on checkpoint" mode as I do not need point of failure recoverability.I was performing a recovery test using a backup which resulted in it being unsuccessful .Error Message received was
"Recovery has failed because a nonlogged operation could not be redone.Use the RESTORE statement to restore all data in filegroup PRIMARY to a pt beyond the nonlogged changes"
Isnt sql*server supposed to prevent a non-logged operation while a backup is in progress?Also how do i prevent such a situation from recurring.
If i switch to single user mode before a backup how do i prevent exisiting users from accessing ... without bouncing my sql*server?
View 1 Replies
View Related
Sep 25, 2001
Hi Everyone,
I did a restore of database the user the original database is admin where it says the user is dbo.
After i did the restore i was able to add admin as user and dbowner but when i tried to change the user it said the user already exists.
How do i create the same..enviroment as or the original system with users..i saw a problem i i drop the user and them recreate it then it cannot find the object or the object which are owned by it are lost..could any one help me with this ...so as how to and what do i need to keep track of while restoring the database and configure the server back with same user names and permissions.
Thanks.
Kavitha
View 1 Replies
View Related
Sep 15, 2000
Hi,
I have two databases on two different SQL Servers,our application is updating these two databases simultaniously.So every time these two databases will be in synchronized state.
Now i want to schedule backup for these two Databases.How can i take backup of these two databases at single point of time.
so that if i restore these two backups on corresponding servers,There should not be any conflicts.
Any suggetions please....
Ananth
View 1 Replies
View Related
Sep 6, 2000
How can I backup and restore a database from one server to another. I am new in this business. I need your help please!!!
View 3 Replies
View Related
Jan 29, 2001
I'm trying to backup a database to remote server first i did add a device using USE master
EXEC sp_addumpdevice 'disk', 'NetworkDevice', 'cabaanpubs.bak'
then
BACKUP DATABASE pubs TO NetworkDevice
it gives me an error saying
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'NetworkDevice'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.
I don't really understand what's goin.
basically i need to synchronize my production database so what am i planning is to take a full backup on that server everynight and then restore it back.
Can some one guide me to take a backup as well as restore on the remoteserver with syntax and what does it mean to add a device...i could not understand.
Is there any other process that's much faster to implement.
i appriciate your support and help .
View 1 Replies
View Related
Aug 30, 2000
Whenever I restore a backup on sqlserver 7.0 and create a new database from it, I always end up having problems with the users existing in the backup.
To enable those users to have access, I end up creating logins with those names and when I try granting those users Database access, I get the error message that the user already exists in the database.
Could some one tell me the right way to restore the backup and having all the users of the database also restored in the proper manner.
View 3 Replies
View Related
Dec 13, 1999
WE are using sqlserver 7.0 & backing full database using Seagate backup ver 7.2 on a tape drive.
I have following questions if anybody could help
1]How do I restore a single table backup from the tape backup without restoring the full database first on the disk & then running import/export
utility to transfer/ copy that particular table to production database.
Is there any third party backup utility which allows for a single / selected table restore?
2]What are the steps or if anybody has the script for tansfering logins/users
with permisssions & without deencrypting the passwords when transfering from one server to another server.
View 1 Replies
View Related
Nov 26, 2006
Hi there,
I am new to administration. i would like to create a development environment out of production database.
for this i have to backup the production database on a regular basis. then use this backup and restore it to a database on different. i can do this task, but i want to automate this task to do it on regular basis.
i would like to schedule my backup time. and immediately after backup i want to restore it to the database on other server, over writing existing data. what is the best way to do this???
thanks,
kishore
View 6 Replies
View Related
Apr 20, 1999
I have a question related to SQL 6.5. We have a SMS 1.2 server which uses SQL 6.5. Two months ago, one of the NT admins did a NT backup of SMS database(sms.db) and then formatted the HD. Now, we need the SMS server back again. We installed the NT server, SMS server snd SQL server on that machine. The problem is, we now want the SQL server to recognize our SMS database (SMS.db file). We don't have any SQL backup of any database (that means, no copy of master database, no copy of other databases. IS THERE A WAY TO RECOVER SO THAT SQL SERVER RECPGNIZE THE SMS DATABASE(SMS.DB FILE)
Please help me out.
I would really appreciate that
Jazib Frahim
View 2 Replies
View Related
Sep 21, 2006
Does some one know how to back up a dts and then restore from a backup?
View 5 Replies
View Related
Feb 2, 2004
I have a database xxxx on server a, I want to copy this DB to server b.How can I do this By back and restore.
WHere can take this back up?I want to take this to a personal folder and wanted to restore to server b from this folder.Is it possible?
Thanks.
View 2 Replies
View Related
