If you don't have a SQL backup, you may be able to use Restore From Previous Versions in Windows if you have a suitable Restore point. But you might have to restore the entire folder that contains the database files.
If you don't have a SQL backup, you may be able to use Restore From Previous Versions in Windows if you have a suitable
Restore point. But you might have to restore the entire folder that contains the database files.
How I can restore my database within specific time ..can u explan it within more specifically...Like I want to resoter my database 10 am
---- Mark It As A Answer If It Helps You --- Thanks ... asp.net1
Interested in Azure, ASP.NET (MVC), jQuery, WCF, Silverlight, EF, MS SQL, ...
You can only do that if you have a suitable restore or backup point in Windows. First, you need to right-click on the folder that contains the mdf file. Click Restore Previous Versions and then look to see what (if any) options you have available to you.
asp.net1
Member
105 Points
138 Posts
Recover Data
Nov 04, 2012 08:45 AM|LINK
From Database Table I have deleted all data ...
I dont have any backup file....Now I need to get all data which I have deleted
How I can do that ?
Interested in Azure, ASP.NET (MVC), jQuery, WCF, Silverlight, EF, MS SQL, ...
Mikesdotnett...
All-Star
154927 Points
19867 Posts
Moderator
MVP
Re: Recover Data
Nov 04, 2012 11:32 AM|LINK
If you don't have a SQL backup, you may be able to use Restore From Previous Versions in Windows if you have a suitable Restore point. But you might have to restore the entire folder that contains the database files.
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
asp.net1
Member
105 Points
138 Posts
Re: Recover Data
Nov 05, 2012 07:13 AM|LINK
How I can restore my database within specific time ..can u explan it within more specifically...Like I want to resoter my database 10 am
Interested in Azure, ASP.NET (MVC), jQuery, WCF, Silverlight, EF, MS SQL, ...
Mikesdotnett...
All-Star
154927 Points
19867 Posts
Moderator
MVP
Re: Recover Data
Nov 05, 2012 07:23 AM|LINK
You can only do that if you have a suitable restore or backup point in Windows. First, you need to right-click on the folder that contains the mdf file. Click Restore Previous Versions and then look to see what (if any) options you have available to you.
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
asp.net1
Member
105 Points
138 Posts
Re: Recover Data
Nov 05, 2012 08:34 AM|LINK
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL
Right Click On Data Folder
Tab : Previous versions,
Folder versions: there are no previous versions available
Interested in Azure, ASP.NET (MVC), jQuery, WCF, Silverlight, EF, MS SQL, ...
Mikesdotnett...
All-Star
154927 Points
19867 Posts
Moderator
MVP
Re: Recover Data
Nov 05, 2012 09:02 AM|LINK
Then you are out of luck.
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter