June 20, 2013 at 9:38 am
hie frnds,
i had a database let me called 'job' and having 5 tables that database is in production server.now when i took backup and restored in development server 'job' database had only four tables .so what should i do now?
please help me...
June 20, 2013 at 9:51 am
Are you 100% sure you restored the correct backup?!
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
June 20, 2013 at 9:52 am
Not sure. Where was the last place you saw the table? Have you looked everywhere? Behind the sofa?
In all seriousness, it's not really possible for a backup and restore job to complete successfully and a table to go missing. Perhaps there is a permissions issue that's stopping your user being able to see the missing table on the development server, or maybe the time of the backup was before the missing table was created?
June 20, 2013 at 10:02 am
A restore will always recreate the database in exactly the same state it was at the time of backup. If the restore restored 4 tables, then the database at the time of backup only had 4 tables. Check the date of the backup you used (RESTORE HEADERONLY)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2013 at 4:33 am
yes
June 24, 2013 at 4:36 am
thank u so much for sharing ur valuable time with me...
June 24, 2013 at 4:39 am
okey gail..i will do what u said ...thank u so much..
June 24, 2013 at 4:43 am
Take latest backup at appropriate location and restore it.
Either Create new blank database and restore on it.
June 24, 2013 at 4:44 am
i had a database and that is in online mode.i like to restore that database with available backups.so in that particular database lot of users are working.so is it possible to restore that database or else i should restore that database with single user mode and kill all the users as well keeping the database in offline in production server..
what exactly has to be done and on what are the conditions to restore a database before we have to follow in production server?
please help me..
June 24, 2013 at 4:45 am
A restore will always disconnect all users in that database and overwrite that database with the contents of the backup.
What exactly are you trying to do?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2013 at 4:55 am
Aadhar Joshi (6/24/2013)
Either Create new blank database and restore on it.
Why would you create a database then restore over it? Waste of time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2013 at 4:56 am
thnx i learned a new information from you..my doubt is can i restore a database even it is in online mode?
June 24, 2013 at 4:59 am
thank u so much
June 24, 2013 at 4:59 am
You can restore over an online database, but the restore will have to disconnect all users (or you'll have to disconnect all users) and then the restore will overwrite the database with the contents of the backup file.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2013 at 5:01 am
U can create staging database with latest backup made it to appropriate and using switch database, u can switch to your original database. If your dayabase has large size and it could take longer to restore.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply