restore log backups to another server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » restore log backups to another server

13 posts, Page 1 of 2

1 2 »»

restore log backups to another server

Rate Topic

Display Mode

Topic Options

Author

Message

mah_j

Posted Monday, October 08, 2012 2:14 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 6:00 AM
Points: 90, Visits: 1,006

Hi every body

I have a database in server A and i have a friday job that takes a full and a daily job that occurs every 5 minutes and takes log. my boss wants me to restore database on server B and keep the databae on server B ,sync with server A (for just reporting),the problem is that both of the sql servers are in windows authentication mode and they cant see each other so i cant have log shipping.
what i did is :
i use map network to see the drive on server A to have the backup files and restore full backup with standby (because we just want to select from it).
how can i restore all log files and keep it sync with server A?

i create a job and with use of EXEC xp_cmdshell 'dir d:\' ,insert the log backups in a table
then with a cursor i restore them one by one (i select only logs that were taken today)
and this job occures onec at night, but he wants a better way,he said find a way like registering backups(full and log) in server B.is it possible?or does any body have better idea?

Post #1369663

opc.three

Posted Monday, October 08, 2012 10:04 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:24 PM
Points: 6,826, Visits: 11,950

No sense in reinventing the wheel. Even though the servers cannot communicate directly you can still use Log Shipping. You'll just need to automate the copying of the tran log backups from server A to a place where server B can reach them so it can restore them.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1370149

mah_j

Posted Monday, October 08, 2012 11:34 PM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 6:00 AM
Points: 90, Visits: 1,006

thanks a lot for your reply

how can i restore logs to server B?
i use Map Network Drive so i have a drive for backups in server B but in log shipping , secondary server instances and databases when i want to add server B to set restore transaction log how can i connect to server B?

Post #1370168

Perry Whittle

Posted Monday, October 08, 2012 11:58 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:58 PM
Points: 5,242, Visits: 11,259

mah_j (10/8/2012)

i use map network to see the drive on server A to have the backup files

The way i am understanding what you have said above is that on server b you have a mapped drive to server a, is that correct?

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

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1370172

mah_j

Posted Tuesday, October 09, 2012 12:12 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 6:00 AM
Points: 90, Visits: 1,006

yes exactly as you said.

Post #1370176

Perry Whittle

Posted Tuesday, October 09, 2012 1:19 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:58 PM
Points: 5,242, Visits: 11,259

mah_j (10/9/2012)

yes exactly as you said.

So how can you state that the servers "cant see" each other.
The access you are describing requires Netbios ports to be opened!!!

If you can map a drive between servers you can use Log Shipping Wink

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

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1370190

mah_j

Posted Tuesday, October 09, 2012 1:35 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 6:00 AM
Points: 90, Visits: 1,006

both of sql servers are in windows authentication mode i cant connect to server B from server A
also the log on services for both of them are local system.

Post #1370197

Perry Whittle

Posted Tuesday, October 09, 2012 1:41 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:58 PM
Points: 5,242, Visits: 11,259

are the servers in different domains or a workgroup?

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

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1370199

mah_j

Posted Tuesday, October 09, 2012 1:50 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 6:00 AM
Points: 90, Visits: 1,006

the servers are in a workgroup.

Post #1370205

Perry Whittle

Posted Tuesday, October 09, 2012 2:36 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:58 PM
Points: 5,242, Visits: 11,259

mah_j (10/9/2012)

the servers are in a workgroup.

To use Log Shipping in a workgroup see my article at this link Wink

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

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1370218

« Prev Topic | Next Topic »

13 posts, Page 1 of 2

1 2 »»

Permissions