Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Restore Syntax Expand / Collapse
Author
Message
Posted Friday, November 29, 2013 10:21 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 11:57 PM
Points: 8,234, Visits: 16,383
So these are native backups from 2005 rtm?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1518576
Posted Friday, November 29, 2013 10:35 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 14, 2016 10:14 AM
Points: 5,016, Visits: 4,810
I created the maintenance plans and I had to copy and paste the T-SQL Code for the Plan/Job would not run.


For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1518579
Posted Friday, November 29, 2013 11:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 16, 2016 7:56 AM
Points: 2,927, Visits: 8,986
I don't understand what the current problem is. Did your restore scripts work ?

Are the maint plan & jobs related somehow, or a separate problem ?



Post #1518581
Posted Wednesday, December 4, 2013 4:49 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 11, 2016 3:52 AM
Points: 287, Visits: 1,171
Well I know you've done it via the GUI now, but the 3rd file looks like a full text index.

You could have just specified the path in the same way as the other two, i.e.. WITH MOVE...




Check Your SQL Servers Quickly and Easily
www.sqlcopilot.com
Post #1519838
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse