Double Take is replication software, typicaly used between Live and your DR site.

http://www.doubletake.com/english/solutions/workload-availability/Pages/sql-recovery.aspx

http://blogs.techrepublic.com.com/window-on-windows/?p=103

Backup enables you to do recovery 🙂 ( I assume you are referring to restore, and not a db in Recovery mode)

Ok, all jokes aside, backup is: Making a copy...

I'm going to do you one better......

Start by doing your own script, post it, and we will assist from there....

No use in...

write a query to select all the applicable data to this client - export to new table in new database, backup the new database.

write a query to select all the applicable data to this client - export to new table in new database, backup the new database.

In 2000 simply use

Select count (*) from sysdatabases --without the . between sys and databases

and not

Select count (*) from sys.databases

Next time dont put sql 2000 questions under the 2008...

another (not so efficient) method:

SELECT top 1 database_id as DB_COUNT

FROM sys.databases

order by database_id DESC

SELECT COUNT(name) FROM sys.databases

Hi Brad, interesting topic, but also very relevant!

As the only DBA in our environment, I have the privilige of running the show myself, and everyone else relying on my advice...

Similar Topic:

http://www.sqlservercentral.com/Forums/Topic518031-357-1.aspx

No, it's 2 seperate packages.

Quoted from MSDN -

"<drive>:\Program Files\Microsoft SQL Server\MSSQL10.<instance_name>\MSSQL\Binn\."

I'll assume you are correct then, and also believe it must be in the same directory...but I could be wrong. 😉

ramu.guggilla (1/20/2010)

---

when try to copy the log file it is showing message "cannot delete DB name: it is being used by another person or program". i tried to kill...

Since you didnt provide info on your current backup strategy, have a read through the following and see if it applies.

http://support.microsoft.com/kb/321836

ELSE....(hehe)

provide more information on what and when you backup with...

might want to add:

High CPU, Memory and disk utilization....log percentage used....

Change in DB Status (Online -> offline/Single_User etc..)