Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restore Database using backup file Expand / Collapse
Author
Message
Posted Tuesday, July 2, 2013 10:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 8:31 AM
Points: 236, Visits: 934
I need help in using the backup file. I am trying to restore the sql database and I want to avoide the date and use astrick so how would I do that?


example:MyDb_backup_2013_06_30_231639_7324894.bak

Want to use like: MyDb_backup*.bak

Can you please help
Post #1469657
Posted Tuesday, July 2, 2013 11:01 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 AM
Points: 42,445, Visits: 35,501
When restoring you have to specify the exact file name of the backup in the RESTORE statement


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1469670
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse