Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Restore Database Help

Author  Topic 

Sonu619
Posting Yak Master

202 Posts

Posted - 2012-12-21 : 17:11:32

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

212 Posts

Posted - 2012-12-24 : 01:02:24
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
   

- Advertisement -