SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Restore Database Help
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Sonu619
Posting Yak Master

195 Posts

Posted - 12/21/2012 :  17:11:32  Show Profile  Reply with Quote

Hi Guys,

I have a quick question, I want to create a job to restore my database every day.
My Database Name = Hedicald
Here is my .bak file = \\lfinal\d$\mssql\backup\HMeical.bak
Here is my .mdf file = \\lfinal\d$\mssql\data\HMedical.mdf
Here is my .ldf file = \\lfinal\e$\mssql_logs\HMedical.ldf

Note:- My database is different from .bak,.mdf & .ldf file. I want to restore my database with different database.

Thank in advance.

prett
Posting Yak Master

USA
192 Posts

Posted - 12/24/2012 :  01:02:24  Show Profile  Visit prett's Homepage  Reply with Quote
I found some useful resources on topic "How to restore my database with different database." Here are the links:

http://msdn.microsoft.com/en-us/library/ms186390.aspx
http://msdn.microsoft.com/en-us/library/ms190447%28v=sql.105%29.aspx
http://www.techrepublic.com/blog/window-on-windows/how-do-i-restore-a-sql-server-database-to-a-new-server/454
http://www.mssqltips.com/sqlservertutorial/122/retore-sql-server-database-to-different-filenames-and-locations/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000