eseosaoregie (4/1/2010)

---

I am currently setting up Log shipping on 4 our produciton databases. As 3 of these databases are not highly transactional we take transaction logs once a day. I...

The second query will have to wait until the...

saghbash (4/1/2010)

---

Option one is far simpler and uses less resources, but you could only restore to 7pm the previous evening.

Thanks james for the prompt response. I am for the first...

if the full backup is most recent and diff backup was taken after this full...

yogaanand.me (3/29/2010)

---

hi friends

Recently i changed my BACKUP Place in different server.. and working fine

when i am running

"SELECT * FROM backupmediafamily"

the Physical_device_name is showing old path instead of new...

u can also run the following command to disconnect all users

alter database <dbname> set single_user with rollback immediate

if u're sure maint. plan took backup successfully, then someone might have deleted the backup files..

Paul Ibison's site is good for replication.

http://www.replicationanswers.com[/URL%5D

You can start P2P replication here

if u're running enterprise edition, you can go for peer to peer replication...

Looks like there is a missing log backup file prior to JDE_PRODUCTION_20100112090000.trn

you can script out logins from the master database and jobs from msdb database so that in the even of your database getting crashed, you can recover logins and your...

If you just need to connect to sql servers running on different machines, you can install client tools/SSMS only..

I came across with this article on adding an article to existing publication. Might help you.

http://deepakrangarajan.blogspot.com/2009/01/sql-2005-transaction-replication-adding.html

Ratheesh.K.Nair (12/17/2009)

---

think you cant backup to multiple devices at a time.

You can take backup to multiple locations or drives in a device.

backup database db_name to disk=''path1,

...

It does connect to named instances.

You need to provide the instance name in the following format

ServerName\InstanceName

in the servers.txt file.