How did you split your database files on your primary server?

Now if I understood you correctly your stanby server has only one drive, in this case what you have to do is before configuring your databases for logshipping, initially take...

I didn't understand your question, can you explain more in detail?

Please refer to SQL Server BOL

or

http://msdn.microsoft.com/en-us/library/ms186858(SQL.90).aspx

Please refer to SQL Server BOL.

nitin.doshi (8/12/2009)

---

We have a productions server with 200+ databases. For BCP, we want to use log-shipping. What will be best method to configure the same.

1) Using right-click-on-database and ship...

While configuring logshipping, when configuring secondary server instance under restoration tab, there are two options 1st to to be in norecovery state and 2nd in standby state, I think you...

Will Sharepoint be installed and share resources with database server, or does Sharepoint has its own box?

Once sharepoint server is installed and configure a site, 3 different databases with suffix...

GilaMonster (8/11/2009)

---

Ok, couple things.

By truncating the log you have broken the log chain, will not be able to take log backups and will not be able to restore to a...

Hi Rob,

I don't know what exactly is happeneing. If possible can you run a trace on primary server, by putting a filter running with your account and configure...

rob.shelton (8/10/2009)

---

Yes.[/quote

Please execute the following and see whether it has any data in that or not on Primary Server

select top 1 * from msdb.dbo.log_shipping_primaries

select top 1 * from msdb.dbo.log_shipping_primary_databases

on Secondary...

When you configure logshipping through wizard once final step is done, does it say that logshipping configuration is successful?

How...

ps (7/29/2009)

---

murthykalyani (7/29/2009)

---

There is no such table by the name backupfile in msdb database.

Ram[/QUOTE]

The table is present.

Please query by joining these tables backupset and backupmediafamily and you can...

Scripting of objects can be done through SMO. But I have not tried.