vrabhadram (6/24/2009)

---

i've regular backups full & transaction log backups. How it will be affect if i do rebuild with switching from bulk_logged to full.

recovery process:

daily fullbackup at 1:00 am

transaction...

Can we backup the same database to two different servers at the same time?quote]

you can achieve so by using mirror to clause of backup statement

backup database test

to disk='c:\test1.bak'

Mirror to...

Glad you're finally done with your DR using log shipping.:-)

Can you elaborate more on Launch Mirroring? Are...

California (6/23/2009)

---

i was wondering, is there a way, i automatically kill the blocking sessions id? If this can not be done from SQL Server, is there a third party product...

nscott (6/23/2009)

---

I have run both recently, and have repeated the tlog backup today with the option to truncate the log checked on. I run them from the context menu....

Mike (6/23/2009)

---

I'm in charge of configuring, setup, security, etc on all servers as well as database servers. I want the developers to use 1 Id and password per database...

Thanks for correcting Noel. Appreciate it 🙂

Yes, use sqlcmd instead of osql.

i just hope u're checking for your database

select log_wait_reuse_desc from sys.databases where name='MyDBName'

If it's not a production server, try putting the recovery mode of your database to SIMPLE and then...

i dont know if there is a way to find 'how' it was created. However, you can query sysjobs to see who is job owner. check owner_sid column there.

OR run that with xp_cmdshell if u need to create a job in sql server itself....

see if this helps u

http://www.sqlteam.com/article/osql-storing-result-of-a-stored-procedure-in-a-file

Using the commands there you can store the results to an external file.

Remember to run this from command prompt instead. You can create a windows...

nscott (6/23/2009)

---

Thanks for your help! The field in question contains a value of "LOG_BACKUP". As mentioned above, I have performed full backups of the transaction log, with no...

if you're running this query from query window, you've option to save the results in 1)grid, 2)text and 3) file. There are three buttons on the top right side for...

Why not use bulk insert?

insert * into server2.db2.dbo.table2 from table1

Also, put the secondary server in bulk logged mode(if it's in full recovery model) which will prevent log files on secondary...