Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Perry Whittle » Using Disparate File Paths in SQL Server...
Add to briefcase
15 posts, Page 1 of 2
12»»

Using Disparate File Paths in SQL Server Database Mirroring Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Perry Whittle
Posted Monday, February 28, 2011 10:29 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:33 PM
Points: 5,201, Visits: 11,150
Comments posted to this topic are about the item Using Disparate File Paths in SQL Server Database Mirroring

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1070983
S. Kusen
Posted Monday, February 28, 2011 10:30 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 09, 2013 2:25 PM
Points: 956, Visits: 873
Excellent tip to "trick" SQL into thinking we did a full backup/restore of the DB to be able to move the new database file.

Cheers,
Steve
Post #1070984
dibbydibby
Posted Tuesday, March 01, 2011 2:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:31 AM
Points: 113, Visits: 470
nice article. one question?

in your backup TLog statement did you mean to say.... 

BACKUP DATABASE AdventureWorks TO DISK = '\\hanode1\backup\AdventureWorks_createnewfile.trn' WITH INIT

?
Post #1071040
Perry Whittle
Posted Tuesday, March 01, 2011 2:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:33 PM
Points: 5,201, Visits: 11,150
dibbydibby (3/1/2011)
nice article. one question?

in your backup TLog statement did you mean to say.... 

BACKUP DATABASE AdventureWorks TO DISK = '\\hanode1\backup\AdventureWorks_createnewfile.trn' WITH INIT

?

Hi
well spotted, no the backup and the restore statement should read

BACKUP LOG
RESTORE LOG

Regards
Perry

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1071042
dave-dj
Posted Tuesday, March 01, 2011 2:32 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:26 AM
Points: 380, Visits: 1,013
good article and good tip for addining files without the need to do a full backup and restore.

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1071054
john.knight-557608
Posted Tuesday, March 01, 2011 2:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 10, 2013 8:17 AM
Points: 8, Visits: 63
Hi Perry,

Another good article, thanks for the tip!

Cheers

John
Post #1071056
george sibbald
Posted Tuesday, March 01, 2011 11:06 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:23 PM
Points: 5,264, Visits: 11,191
nice article Perry and very useful info.

I think the lesson to take away though is to set your live and failover servers up with exactly the same drive\directory structures in the first place.

---------------------------------------------------------------------
Post #1071431
UMG Developer
Posted Tuesday, March 01, 2011 1:17 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148
Thank you very much for the article, it is good to learn about the pitfalls before actually falling into them.
Post #1071543
SQLRNNR
Posted Tuesday, March 01, 2011 2:02 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:46 PM
Points: 18,732, Visits: 12,329
Nice article Perry. Thanks


Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1071575
Perry Whittle
Posted Tuesday, March 01, 2011 7:44 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:33 PM
Points: 5,201, Visits: 11,150
Guys

Thank you very much for all your kind replies I'm glad you find it useful

george sibbald (3/1/2011)
I think the lesson to take away though is to set your live and failover servers up with exactly the same drive\directory structures in the first place.

George I couldn't agree more, although sometimes you may inherit a system and will have to roll with it. This is especially for these types of systems

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1071695
« Prev Topic | Next Topic »

Add to briefcase
15 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.