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 ««12

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:54 PM
Points: 6,462, Visits: 13,909
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:57 PM
Points: 4,242, Visits: 4,290
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: Yesterday @ 8:54 PM
Points: 2,832, Visits: 8,505
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: Thursday, October 2, 2014 8:05 AM
Points: 283, Visits: 1,119
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