from the primary, can u connect to secondary and fire queries?

If you have setup log shipping, you'll need to remove transaction log backup from your maintenance plan or else the log chain will break and your log shipping will fail.

is your post incomplete? what is the query?

No that is not the reason.

Whenever the log is backed up, it's automatically truncated. You need to check out why the job failed? there can be many reasons for failure....

to add to what fox has said, whenever a log file grows to a certain size, the size is not reduced automatically unless you shrink the file (which is a...

No, this would not work. You...

Thanks Lowell. That didnt click to me :w00t:

mehranphp (9/17/2009)

---

hi, i delete db with sql server 2000 and lost mbf and ldf files.

so, i recovered with software Recovery ,

then...

can u post the error message?

The other way is to:

1. create a linked server on server2 pointing to server1. from there insert...

Silverfox (9/17/2009)

---

ps_80 (9/17/2009)

---

There is a number suffixed at the nick name... I think this is done to maintain uniqueness to the nick names? Personally, i dont like adding a number...

There is a number suffixed at the nick name... I think this is done to maintain uniqueness to the nick names? Personally, i dont like adding a number to my...

you may get anywhere between INR 3 lakhs to 5 lakhs here for 3 yrs of experience. That depends on your candidature and company. some companies are giving hike more...

You should backup your log files every hour or so. Remember that you keep ur database in full recovery mode only to recover your database to point in time from...

gugan_ta (9/17/2009)

---

Hi,

I have to copy a table from server1 to server2.

created the SP where table frm server1 should be copied to server2 (linked server in server1)

have tried the following query...

explorer.exe is the executable that you can run...

eg explorer c:\ will open the explorer with initial folder set to c:

Its working in command prompt but not with xp_cmdshell.. 🙁