How to backup transaction log onto non-local hard disk

Can anybody tell me, if it is possible to backup a sqlserver6.5.
transactionlog to a non-local hard disk, i.e. a directory on a disk that is
somewhere else on the nt4.0 network?

When I select the disk dump option in the backup/restore menu in the
SQLServer Enterprise manager, it only shows the local logical disk drives,
although the server from which I like to backup, has a mapping to the remote
hard disk to be used as dump device.

Am I searching for the impossible or do I overlook something?

Regards,

Martijn

Email to newsgroup or   mrutte@one.ogilvy.nl


0
OgilvyOne
7/28/1998 1:21:48 PM
sybase.sqlserver.general 4269 articles. 0 followers. Follow

2 Replies
591 Views

Similar Articles

[PageSpeed] 34

You can dump to a remote computers hard drive.  One way to do this is to use
the sql as follows:

dump tran dbname to disk = '\\server_name_or_drive_mapping\dumpfile.dat'

search SQL BOL for dump for more info.


OgilvyOne wrote in message <6pkjdd$533$1@newnews.nl.uu.net>...
Can anybody tell me, if it is possible to backup a sqlserver6.5.
transactionlog to a non-local hard disk, i.e. a directory on a disk that is
somewhere else on the nt4.0 network?

When I select the disk dump option in the backup/restore menu in the
SQLServer Enterprise manager, it only shows the local logical disk drives,
although the server from which I like to backup, has a mapping to the remote
hard disk to be used as dump device.

Am I searching for the impossible or do I overlook something?

Regards,

Martijn

Email to newsgroup or   mrutte@one.ogilvy.nl




0
Philip
7/28/1998 1:46:24 PM
Martjin,

Addition to Philips post:
The MSSQLServer service must have permissions to the share. Do not start the
account as LocalSystem.
--
Tibor Karaszi
MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB



0
Tibor
7/28/1998 2:20:35 PM
Reply:

Similar Artilces:

Backup --> TRANSACTION LOG TRUNCATE versus TRANSACTION LOG RENAME MATCH
Hi, I rest my question. I want to do a backup of my log file only and I want to rename the log file. I'm using ASA Sybase 8.0.2. In my ISQL, I wrote : BACKUP DATABASE DIRECTORY 'c:\\database\\backup' TRANSACTION LOG ONLY TRANSACTION LOG RENAME MATCH The backup is executed successfully, but a another log file was created in the original database repertory. I don't want the log file copy created in my original repertory. So, if I add TRANSACTION LOG TRUNCATE, like that, an error occurs : BACKUP DATABASE DIRECTORY 'c:\\d...

'active transaction log' versus 'local transaction log'
Both Cons. Db and remote Db are running on (separate) servers. I start dbremote on both sites from an client-pc. on the Cons.db, the dbremote-window says it uses the 'active transaction log', which is good. but on the remote.db, dbremote uses the 'local transaction log D:\map\dbname.log' in which D: is the Hdisk of the SERVER. result is a non-working dbremote on the client-pc's of the remote site. What must I do to let dbremote use the 'active transaction log' too on my remote site ?? Please show us the dbremote commands you're executin...

full backup vs transaction log backup
What will happen if the full backup is running and the transaction log backup starts or vice versa on ASA? On ASE, the second one will wait until the first one finishes. Thanks The same is true with ASA. Only one instance of DBBackup (or the BACKUP statement) will be active at a time. A second or third instance will block until the first one completes. -- ----------------------------------------------- Robert Waywell Certified SQL Anywhere Associate Sybase's iAnywhere Solutions Please respond ONLY to newsgroup EBF's and Patches: http://downloads.sybase.com ...

Backup from transaction log bigger than backup from database
Hi, I have a database which backup is about 210 Mb however the backup from her transaction log is 540 Mb. I don't understand why. Any idea. On Jun 30, 11:55=A0am, Eve wrote: > Hi, > > I have a database which backup is about 210 Mb however the > backup from her transaction log is 540 Mb. > > I don't understand why. > > Any idea. Mayhaps it has been a loooooooooo-ooooo-ooo-ong time since the last transaction dump, and so therefore there are a loooo-oo-ot of un-dumped transactions. What are the dates of the two files? Depending on your ...

Transaction log backups
Hi, When I perform full backup of a database, do I have to backup transaction log also in order to truncate it? In other words, does a full backup truncate the transaction log "automatically"? I do not have "Truncate log on checkpoint" turned on. This is mid-sized DB in production environment and I intend to backup the tran on hourly basis and perform full backup maybe three times a day. - Auski Auski wrote: > When I perform full backup of a database, do I have > to backup transaction log also in order to truncate it? Yes. Only a dum...

Logging: Disk full
Hi how are you? I'm fairly new to groupwise and all of the problems that may occur, but I believe I have a fairly simple problem to fix(I hope). This morning I was told by a couple of people that they have not been recieving their mail for a couple of days. When I looked at the MTA it reports basically continuosly: Logging: Disk full - disk logging turned off. I've been doing research this morning trying to figure out where these log files are... but have had no luck. I'm under the assumption that I could delete these files to create more disk space...is t...

Transaction Logs And Logging
I work in a shop that does not keep the Sybase transaction logs. We have been mandated to research archiving our logging. The Sybase documentation does not go into great detail about how to do this. Can anyone give me pointers on this, or point me in the way of decent documentation? I understand setting the 'dump transaction' command on the Last Chance thresholds. We have 65 active databases, and the nightmare I have is trying to deal with 65 logs being constantly dumped. Without overwriting each other before they can be copied to tape. Is there an easy way to rename the ...

backup and clearing the transaction log
was wondering what the Backup the Log (remove the inactive part and create a new transaction log) does. I need to write a script that will do this. is it dumping the log to the dump device then truncating the log with truncate_only or something else. I have a sybase book here that says if disaster occurs before you can dump the database, you will not be able to recover any data that added since the last dump. So was wondering at the end do I need to then dump the complete database after I truncate log? Victor On Mon, 22 May 2006 07:20:56 -0700, Victor wrote: >...

Backup
Hello all: I have ASE 11.5.1 running under Solaris 2.6. Each day a backup is done via a cron job. The command executed is: dump database (database name) to "dev/rmt/0c" with capacity=8808000, init It has been my understanding that when a dump database command is executed, that the transaction log is purged. That is apparently not the case. My question is two fold: 1) is there another "switch" to add to the dump database command that will purge the transaction log? 2) Assuming 1 is no, then how do you purge the log on a routine basis and what is a good interval ...

No off-line transaction log file found and on-line transaction log starts at...
Hi all, ASA & ML 9.0.2.3221 Two days ago, one of our remotes stopped syncing, and unfortunately nobody noticed until today, which means that quite a lot of information got entered, and a simple re-sync would result in a considerable loss of data. The database was in E:\DBs\remote.db E:\DBs\remote.log On Tuesday, a backup of the remote for testing purposes was made through Sybase Central to a subfolder E:\DBs\test\remote.db E:\DBs\test\remote.log Ever since then, we are getting I. 10/10 05:24:48. Processing transaction logs from directory "E:\DBs\" E. 10/10 05:24:48. No off-line transaction log file found and on-line transaction log starts at offset 0706435324. I. 10/10 05:24:48. We are looking for a transaction log file starting at offset 0057788176. I. 10/10 05:24:48. Synchronization completed The original E:\DBs\remote.log tran log file is still there, untouched, 88 megabytes large, created last July when we did the first sync. It is not missing, and nothing changed it. I assumed that dbmlsync gets confused if there is another remote.log tranlog file in the subfolder of the remote database folder. Since than, I moved it to E:\backup\remote.db E:\backup\remote.log so, completely out of the folder structure of the real remote database, which is still in E:\DBs\remote.db. Same error message. Thinking that it needs to maybe scan the copy of the log file (which is ~ 56 MB large, so considerably small...

How do I make a backup hard disk image?
Hi I just had my hard disk infected and unable to recover it. So I am going to look at it later and redesign my whole security defense plan. I want to do the following and would appreciate any tips about what free, or paid if necessary, software can accomplish this: Once I have a Windows PC as I need it with all my 3rd party software installed on it can I take another empty hard disk and make a complete copy of it kind of like an ISO image of a CD? This would contain identical master boot record info, the entire Windows OS and my installed software and anything else so t...

database backup + transaction log sequence ?
database backup + transaction log sequence ? using asa9.0.2(3137) on w3k If database is setup to do hourly transaction log only and daily full backup incase their is a need to recover from yesterday's backup then what should be the sequence. Delete corrupt production file.db and move production file.log into corrupted directory Take Yesterdays file.db and file.log and move into production folder Apply transaction logs in choronological order Apply file.log from corrupted production directory. Is this good ? Basically getting a bit confused on when to apply t...

transaction logs /backups with AES encryption
When a database is run using AES encryption, are the database log files encrypted also? According to the following documentation it would appear that the transaction log is encrypted as well: http://dcx.sybase.com/index.php#http%3A%2F%2Fdcx.sybase.com%2F1101en%2Fdbreference_en11%2Fcreate-encrypted-database-statement.html Steve Garland [ASTA] wrote: > When a database is run using AES encryption, are the database log files > encrypted also? > > > > Steve Garland [ASTA] wrote: > When a database is run using AES encryption, are the database ...

Saving form in local Hard disk.
In my HTML form I want to provide a SAVE AS button.When the user click on that button, he should be able to choose the directory, file etc.. and he should be able to save the form to disk.It should work exactly similar to windows default Save As window.When he opens the file back.I should be able to fille the form with file data.how to do this using PowerDynamo.Please help me ASAP. Thanks Murali Krishna. Saving the data to disk where? (Client or Server). PD should be able to save to a file on the Server (using document.value.<property> to retrieve the FORM values and site...

Hard to log onto school networks
Name: Catherine Product: Firefox Summary: Hard to log onto school networks Comments: I go to UC Berkeley and whenever we use the campus wireless network, we have to log in through a login page that loads when our Wireless network is connected to it. For some reason it's really hard for Firefox to load that login page. Usually I have to open up Safari 4 and login through that, and then close it and start using Firefox. The previous version of Firefox didn't have this problem. Browser Details: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1) Gecko/20090...

How to determine non-logged transaction has occured.
For Sybase ASE 12.0 running on HP-UX how can I determine if a non-logged transaction has occured in a database. I would like to monitor for this situation programatically. Thanks. Hi Keith, Non-logged trans are only allowed if the DB option "select into/bulkcopy/pllsort" is true. Now if the option is true and you want to check if a non-logged tran occurred, the only way that I am aware of would be to execute a dump transaction which will fail if there was a non-logged tran. 1> dump tran kr2 to "c:\tmp\kr2.tran" 2> go Msg 4207, Level 16, State 1: ...

need to add Hard Disk for backup purposes
Hi all, I'm new here and really new to Netware. I'm just beginning to get involved with Netware Servers (V 6.5) and am trying to add hard disks to a server for backup purposes. I have two SCSI hard disks to add to this server and wish to name them backup_1 and backup_2. Using the Backup Exec software we have a site license. I want to be able to do an incremental backup Monday thru Thursday and a full back up on Friday on each disk alternating out the disks weekly with one of the disks being off site while the other is in service. I can add the new drive in a Hot manner and then must go through configuring the disk.....during the configuration I'm asked if I want the disk to be a part of a pool or something to that effect. What do I want to do here? Actually I'd like to know just what is a pool technically? I've got several books on Netware and none of them has painted me a clear picture of just what a pool is. I'm kind of excited to be learning about Netware I hope you all can bear with me as I stumble through this. Thanks so much!!! -- efisd ------------------------------------------------------------------------ A pool is a structure between a volume and a partition. It allows, for instance, you to have multiple volumes in a pool, each of which can dynamically grow to use unallocated space within the pool on demand. 'Novell Documentation' (http://www.novell.com/documentation/oes2/s...

Mirror crashing which backup with transaction log rename
Just wondering if anyone else has experienced a crash of the SA10 mirror when performing a backup with a transaction log rename? It does it every time I try to do the backup with the rename option. I did get prompted to send the report to ianywhere and I did. I don't think it should crash, that's not particularly friendly :) Did you use dbbackup.exe or the BACKUP statement? I am not sure how you would get BACKUP to run on a mirror, and I think running dbbackup.exe violates the rule that a mirror database does not accept a connection. I must confess, I don't compl...

Transaction Log to Audit Log
Hello Everybody: We are developing distributed Powerbuilder application with SQL Anywhere 5.5 DB as a back-end. One of the requirements is to have audit log tracking for data changes in some pre-selected tables. The audit log table can look something like this: create table AUDIT_LOG ( LOG_REC_NO integer not null, TABLE_CHANGED char(128) not null, USER_NAME char(128) not null, TIME_CHANGED timestamp not null, SQL_STMT varchar(254) not null ); Before dev...

Disk-to-disk backup with GWTSA
Hello, Does anyone know of a way to use the GWTSA functionality to directly copy the live GroupWise databases from one server to another? (Or from one volume to another on the same server? The idea is to get cheap insurance by simply scheduling a job over the weekend to copy the files, and just set the backup copy up as a restore area in the event it is needed. I know about GWBACK32 and DBCOPY, but some people have reported compatibility problems with GroupWise 6.5, and it also adds the unnecessary step of having to run the utilities on a Windows box. We could also use o...

Problemswith SQL Remote and Backup of the transaction log
I have a database for developing, i have a threshold procedure in this database to dump the log, and it was working fine. Then I installed the sql remote, and the procedures of this, i made some tests with replication and it works, but my log grew up, and the threshold didn't fire, so i tried to dump the transaction with no log, but i can�t So, I uninstalled the sqlremotestored procedures, and I added a new device for my log, and retried to dump it with no log, but again I couldn't do it. I did the dump of the entire database and it works fine, also i did the dump of the t...

Backup transaction logs at both consolidated and remote database
Any advice in regards to be able to safely backing up transaction logs at both consolidated and remote database? At the consolidated database (running on an NT Server) we can run dbbackup (with the -r option) as a service and be trigger to connect to the running consolidated database to backup and truncate the database. But at the remote database, we do not want the user to have to run dbbackup. Is there any 'safe' option in SQLRemote such that it can backup and truncate the transaction log? TIA Michael Mok Consultech There is a -x switch on dbremote that will...

linux log in/password on hard disk boot
I'm a total newbie, when I try to boot from hard disk rather than CD, I'm asked for a Linux Login and Password. How do I find what these are? -- lesliejohn ------------------------------------------------------------------------ -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 What did you set for them? If this is a full login screen with username/password they are values you (or somebody else in charge of the box) set during the installation. Worst-case scenario you can rebuild the box. Good luck. lesliejohn wrote: > I'm a total newbie, whe...

Transaction log backup page only partially full
What do these warnings mean? They are showing up in the 9.0.2.3124 request level log file for a busy network server: 06/01 16:18:25.944 ** WARNING conn: 356 code: 110 "Transaction log backup page only partially full" 06/01 16:18:25.944 ** WARNING conn: 1040 code: 110 "Transaction log backup page only partially full" 06/01 16:18:25.944 ** WARNING conn: 85 code: 110 "Transaction log backup page only partially full" 06/01 16:18:25.944 ** WARNING conn: 2770 code: 110 "Transaction log backup page only partially full" Do they have somethin...

Web resources about - How to backup transaction log onto non-local hard disk - sybase.sqlserver.general

Transaction cost - Wikipedia, the free encyclopedia
Bargaining costs are the costs required to come to an acceptable agreement with the other party to the transaction, drawing up an appropriate ...

Mike Schroepfer, Colin Stretch, Mark Zuckerberg Detail Facebook Stock Transactions
... and CEO Mark Zuckerberg submitted Form 4 filings to the Securities and Exchange Commission Wednesday detailing their Facebook stock transactions. ...

Unilever’s charitable app uses Timeline and subscription billing; Facebook agrees to take only 5 percent ...
... this week, including subscription payments and the new Open Graph-enabled Like action . Betapond says Facebook agreed to take a 5 percent transaction ...

Transaction Network Services - LinkedIn
Learn about working at Transaction Network Services. Join LinkedIn today for free. See who you know at Transaction Network Services, leverage ...

Transaction trends show it 50 years since cash and it is dying out
AUSTRALIAN dollars and cents turn 50 one week from today, but don’t expect notes and coins to last another 50 years.

New Service Mines 120 Million Consumers' Card Transactions for Marketer Insights
... online to help advertisers target and measure ad campaigns, more companies than ever are creating new revenue streams from offline transactional ...

Citigroup Blocks DraftKings, FanDuel Transactions in N.Y.
Citigroup Inc., the world’s biggest credit-card lender, is blocking transactions by New York state residents on the two biggest fantasy sports ...

Renewables Account For Lion’s Share Of Energy Transactions In 2015
Renewables accounted for the lion’s share of all power and utility transactions during 2015, according to a new report from EY. EY’s new report, ...

Citi Now Blocking DraftKings, FanDuel Transactions In New York State
... from transacting any business with either site. The bank confirmed the news to Bloomberg this afternoon, saying that the halt on DFS transactions ...

Apple Pay only makes half as much per transaction in China
Apple Pay may have finally launched in China, but it seems that Apple flinched first in its negotiations with Chinese banks over their adoption ...

Resources last updated: 3/5/2016 6:11:35 PM