Hi,

you might plug in an usb-drive, restore using the usb-drive for the log file, then shrink the new log file to 1 GB and move it to the destination drive.

regards

karl

What level of cpu activity do you get during log backups?

Copying and doing direct backups would generate the same amount of network traffic. I prefer local backups simply because i can do the backups even if my second server fails. In...

Hi,

if you back up to a different server a whole lot of factors get added. There can be DNS problems, permission problems, physical problems, driver problems...

What's the size of the log...

Hi,

i'd recommend gzip, which is gnu zip, open source and free.

http://gnuwin32.sourceforge.net/packages/gzip.htm

regards

karl

Hi,

you might create a new procedure do do the log restores. Get the apropriate log backup files from the filesystem (depending on the file date) and restore them to a...

Hi

-------------------------------------------------------

net use x: \\server\share /user:domain\login password

copy x:\path\file c:\path\file /y

or

xcopy x:\path\file c:\path\file

or

robocopy x:\path\file c:\path\file

net use x: /delete

------------------------------------------------------

The green stuff...

Hi,

the main reason to have a database set to "full recovery" is to be able to do a point-in-time recovery.

Imagine the following scenario:

You do a full backup,

you do log backups,

you do...

Hi,

Create a new step.

Under Type choose "ActiveX"

Under Language choose "Visual Basic-Script"

In command window type vbs-code...

regards

karl

Hi,

did you try to call 'dbo.[Patient_Dem2]' instead of 'dbo.Patient_Dem2' ?

regards

karl

Hi,

you need a routable protocol, preferably tcp/ip.

You need a working route to the server.

You need to be able to access the SQL Server port, normally 1433.

As Ron proposed, an...

Hi Bill,

have a look at the job doing the full backup. If that job has a step that truncates the log (backup with truncate_only) you should convert this stap to...

Hi,

if you do

BACKUP DATABASE [ABC] TO DISK = 'F:\Database Backup\User Databases\ABC\ABC.BAK'  WITH  INIT, NAME = 'Full Bkp'

does that work?

regards karl

Hi,

if you put more then one virtual SQL Server into the same resource group you will have to failover all of them, even if only one actually fails...not something i would like to...

Hi,

why not just use

exec sp_msforeachtable @command1="print 'select ''?'' as TableName, count(*) as TblRowCount from ?' print 'union'"

and forget about replacing !?

regards

karl