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»»

Using Disparate File Paths in SQL Server Database Mirroring Expand / Collapse
Author
Message
Posted Monday, February 28, 2011 10:29 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:36 PM
Points: 6,759, Visits: 14,408
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
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: 2 days ago @ 12:09 PM
Points: 971, Visits: 979
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
Posted Tuesday, March 1, 2011 2:13 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, November 24, 2014 2:50 AM
Points: 116, Visits: 513
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
Posted Tuesday, March 1, 2011 2:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:36 PM
Points: 6,759, Visits: 14,408
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
Posted Tuesday, March 1, 2011 2:32 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 12:23 PM
Points: 405, Visits: 1,140
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
Posted Tuesday, March 1, 2011 2:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 28, 2014 7:10 AM
Points: 8, Visits: 71
Hi Perry,

Another good article, thanks for the tip!

Cheers

John
Post #1071056
Posted Tuesday, March 1, 2011 11:06 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 11:57 AM
Points: 5,888, Visits: 13,062
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
Posted Tuesday, March 1, 2011 1:17 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
Thank you very much for the article, it is good to learn about the pitfalls before actually falling into them.
Post #1071543
Posted Tuesday, March 1, 2011 2:02 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: 2 days ago @ 3:20 PM
Points: 18,064, Visits: 16,099
Nice article Perry. Thanks



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1071575
Posted Tuesday, March 1, 2011 7:44 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:36 PM
Points: 6,759, Visits: 14,408
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 12»»

Permissions Expand / Collapse