April 17, 2012 at 1:10 pm
Production DB - HAS
Test DB - HASTEST
My code: RESTORE DATABASE [HASTEST] FROM DISK = N'E:\SQL\Backups\HAS\HAS_backup_201204031800.bak' WITH FILE = 1, MOVE N'HAS' TO N'E:\SQL\DB\HASTEST.mdf', MOVE N'HAS_log' TO N'E:\SQL\Logs\HASTEST_log.ldf', NOUNLOAD, REPLACE, STATS = 10
GO
User is saying that the restore was not successful because they are not seeing prod data. ??
April 17, 2012 at 1:28 pm
I take it you ran this in a query window in SSMS. When it finished, what message(s) did you see?
April 17, 2012 at 2:03 pm
Restore 10,20,...100% complete
The test db size then matched the production db. So I'm at a loss to their claim that the prod data isn't in test after the restore. I believe these people don't know what they are talking about. I just wanted to cover all my bases.
April 17, 2012 at 2:10 pm
Next question, from SSMS can query the test database and verify the data to the same query in production?
April 18, 2012 at 6:44 am
Yep, I noticed that Prod and Test only had 6 views and when opening each view they all matched # rows returned and then i ran queries on the tables and get the same results. Sorry to take up your time but I think everything is fine. I also checked the overwrite exisiting data box.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply