Physical Path For Backup Device From Enterprise Manager

Jan 20, 2000

View 1 Replies


ADVERTISEMENT

Sql Backup Device Using UNC Path

May 21, 2007

I'm trying to set a backup job to back up my databases to a server other than the server where Sql server is installed. The only options I can see are the local drives on my sql server when I try to set a location or backup device. If I want my backups to go to another server , How do I do that. Currently I'm trying to use a UNC path like \ServerNameBackups. When I try to use a UNC path I get an invalid directory error.

I'm fairly new to SQL Server as you can tell!

Can anyone help me? (I'm using sql server 2000)
Thanks
GEM

View 7 Replies View Related

Single Command To Change The Backup Device Path

Feb 29, 2008



Hi guys.

acutally my network dept. has change the backup file server IP address.. i m now hving problem for taking backup.
i have around 85 backup that runs everyday.. what i m doing now running every single command to drop backup device and then adding again.. but it's taking agess to do..

is there any simple script that just update the device path folder..

Thanks and looking foward.
-MALIK

View 6 Replies View Related

Install Path SQL Enterprise Manager

Jul 12, 2006

Hi,

We want to install SQL Enterprise Manager on a seperate server. Our provider for this server requires us to install SQL EM on a non-default drive/path, d:programs. How can I achieve this?

TIA,

Wim

View 2 Replies View Related

Negative File Size On Database Device In Enterprise Manager

Apr 28, 1999

I have several clients who are reporting a negative file size on their database devices in Enterprise Manager. The sp_helpdevice procedure reports the size correctly. Any suggestions?

View 1 Replies View Related

Backup SQL Database Without Using Enterprise Manager?

May 2, 2004

Hello,

Is there a way where I can backup SQL database without using Enterprise Manager? If there is, may I know how?

View 3 Replies View Related

Backup And Restore With Enterprise Manager

Aug 2, 2005

Hi i need some insistance with Backing up and Restoring database in SQL Enterprise Manager.

I have SQL installed on my local machine, and there is also an instance of the database on the Actual Server.

What i want to do is backup a dbase on the server called 'DATA1' let's call it, and want to then restore it to a new dbase on my local server called 'DATA2'.

What is the best way of doing this, through the wizard in:
What menu's do i go through.

I think where i may have the problem is when i try to RESTORE to my local...That part i an confused at.

Please Help with both Backing up and Restoring, using best practices in Enterprise Manager.

THANK YOU for your help

uno_turko

View 2 Replies View Related

Enterprise Manager Backup Wizard Question

Feb 9, 2004

Is it possible, using the Database Maintenance Plan in Enterprise Manager, to save the backups to another server? It appears that it isn't.

I guess that I was curious as to why you can create a Backup Device and use that functionality when you run the Backup Database option when right clicking a database, but cannot use it within the context of the Maintenance Plan function.

Am I missing something?

Thanks,
Steve

View 2 Replies View Related

How To Backup/restore The Server List In Enterprise Manager

Jul 20, 2005

Hi,In case of a remastering of a client, I need to backup the EnterpriseManager configuration (the groups, the declared servers in thegroups), instead of registering all servers manually once again.Does anyone know how it could be done ?TYArjp

View 2 Replies View Related

Database Backup Failed With Timeout Expired From Enterprise Manager

Apr 13, 2007

Hi,



I have SQL Server 2000 with SP4. When we take backup from Enterprise manager its fails with error "timeout expired". But when we take backup from query analyzer it works.



It seems that through enterprise manager 30 sec is the non configurable timeout parameter set. Checked sysprocesses table during backup but there was no blocking during that time at least for that spid.



Is there a way to find out which process is blocking the database backup? Also, what are the possible scenarios where database backup can be blocked.



Thanks,

Ramesh

View 4 Replies View Related

Transaction Log Physical Device

Mar 18, 2008

Are there any problems or issues with backing up a transaction log to a physical file with the ".bak" extension? We are having some trouble with are hourly trans log backups and I was wondering if this could be part of the problem. Tom.

View 4 Replies View Related

SQL Enterprise Manager Hangs When Choosing A Location On Disk For A Backup Or Restore

Sep 15, 2004

When I select All Actions>Backup Database and then click the ... button to choose a location on the hard drive, SQL Enterprise Manager Hangs and I have to kill it from Task Manager.

All other areas of EM browse the disk drive without a problem. (DTS, File Groups, etc.)

Anyone ever run into a similair problem?

Thanks

View 2 Replies View Related

Device Activation Error . The Physical File Name

Nov 8, 2006

rajesh writes "Hi All

When i attach my production database i got an device activation Error
cannot
attach database."

View 2 Replies View Related

Physical Path Of Sql Server Log

May 30, 2008

hi
where is save the folder of sql server logs ,error logs in sql server 2005

View 2 Replies View Related

CREATE ASSEMBLY Failed Because It Could Not Open The Physical File (The Device Is Not Ready.).

Mar 23, 2007

I have a simple class libarray that I have compiled into DLL using csc.exe

Source code is as follows: -



using System;

using System.Collections.Generic;

using System.Text;

using System.IO;

using Microsoft.SqlServer.Server;



namespace RTFTextParser

{

public class ParseText

{

[SqlFunction(DataAccess = DataAccessKind.None)]

public static String ParseRTFText()

{

return "Imtiaz";

}

}

}

When I try to run the following

CREATE ASSEMBLY RTFTextParser FROM 'E:Class1.dll'

I get the following error

Msg 6501, Level 16, State 7, Line 1

CREATE ASSEMBLY failed because it could not open the physical file 'E:Class1.dll': 21(The device is not ready.).

View 10 Replies View Related

SQL Server 2012 :: Compare A Table With Physical Path

Mar 31, 2015

I have a table with two columns

id | filepath
--------------------------------------------------
1| D:Doc filesThe BestHHT.JPG
2| D:Doc filesThe Bestsealed_pack.txt
3| D:Doc filesThe Bestlsbom.JPG
4| D:Doc filesThe Bestmoc.png
5| D:Doc filesThe Beststock.txt
6| D:Doc filesThe Bestdepot.JPG

And in a physical system there are more files than the table.

D:Doc filesThe BestHHT.JPG
D:Doc filesThe Bestsealed_pack.txt
D:Doc filesThe BestJKSlsbom.JPG
D:Doc filesThe Bestmoc.png
D:Doc filesThe Beststock.txt
D:Doc filesThe BestGDNdepot.JPG

D:Doc filesThe BestCASA.JPG
D:Doc filesThe BestSO.txt
D:Doc filesThe BestBA.JPG

I want to compare the filepath column in table with physical drive files and get the details of files which in table and not in physical and viceversa...

View 3 Replies View Related

Connection Path OK On Device, Not On Desktop

Oct 3, 2007

This code...

string Path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
// Create the connection fConnection = new SqlCeConnection("Data Source ="" + Path + "\TreeNotes.sdf" ;Password ="abcd1234";");
fConnection.Open();

...works on my device, but on my computer it gives SqlCeException with message:
The database file cannot be found. Check the path to the database. [ File name = Program FilesTreeNotesTreeNotes.sdf ]

I've tried all sorts of things, but the computer just can't find the database. I've even tried putting a copy of the database into...
C:Program FilesTreeNotesTreeNotes.sdf...hoping that the computer will find it there.

What am I missing?

View 12 Replies View Related

Newbie Question Regarding Backup Device And Backup Foile

May 10, 2001

This is probably a simple question but I have to ask it anyway. When backing up I can backup to a file on my local drive but I also can create a device to the same location on my local drive. Is this doing the same thing. If I so desire to backup to the local drive(bear with me) what is the difference between creating a device and a file called mybackup or just choosing to backup to a file called mybackup? Should I always create a device? I know these are dumb question but....

Jason

View 1 Replies View Related

How To Get The Backup History Details From A Backup Device?URGENT!!

Dec 7, 2001

How do we know the list of all the backups that are present in a particualr backup device like file# and time of backup taken etc for the purose of restore?

When I run :
RESTORE HEADERONLY FROM BackupDeviceName

it doesn't give that info. Can anyone tell me the exact command to list all the files of a backup device so that I can restore the right one??
Thanks.
Shalini.

View 2 Replies View Related

Problems Running Enterprise Manager And Service Manager

Jul 20, 2005

On one of our machines, all of the SQL Server 2000components except for the main Server component (SQL Servercore) itself were installed (Management tools, etc) a while agoand everything was running fine. Now I go and add/install theServer component and then Service Pack 3a.It seems that Service Manager won't start up (I get an hourglass cursor)and now I find that Enterprise Manager won't run as well. No errormessages appeared and I don't think I saw anything unusual inthe log file.However, I can use Enterprise Manager on a differentmachine and connect to the database (so the databaseitself seems to be running).Any suggestions as to what the problem might be and how tofix it? I like to see if I can repair this without havingto do a reinstall.Thanks.PF

View 2 Replies View Related

Help! Enterprise Manager Turns SQL Server Service Manager Off

Dec 6, 2006

IF someone can assist me. Everytime I load up enterprise manager the service manager turns off. And the enterprise manager can't connect to the local database. But everytime i turn it back on and try to connect again it shuts it off and around and around we go. Help would be appreciated. Thanks.

View 2 Replies View Related

BACKUP To Backup Device Or Disk

Sep 25, 2000

Is there any benefit in creating a backup device and using that in the backup statement over just using a disk file in the backup statement. It seems like extra work to create the backup device with sp_addumpdevice with the file location. Whereas I could just specify the file location right in the BACKUP statement by specifying DISK as the backup device.

View 1 Replies View Related

Delete Backup From Backup Device?

Apr 16, 2004

I dump my databases to backup devices each night.

However would like to purge old backups - say older than a week - from the device.

Is it a case that I have to drop and re-create the devices every 7 days or can SQL do this for me?

I have seen the RETAINDAYS claus but it applies to tape backups only?

Thanks

View 1 Replies View Related

Why Use A Backup Device Vs. Backup To Disk?

Jul 20, 2005

In SQL 2000, is there an advantage to defining and using a backupdevice versus just backing up to disk?Currently, I've got a SQL Backup job set to run once per day, withtransaction log backups running every hour. The db and backups arewritten directly to folders on an external disk array. I've neverconfigured an actual Backup Device within SQL. Does creating a BackupDevice offer any advantages not available with my current backupmethod?Thank you for any help.Jason

View 1 Replies View Related

Backup Device??

Feb 23, 2004

Hi all,

I want to store bakup file on the computer on netword, so make a backup device on the other computer, it ok. after that i make an full backup, there is an error : "Can not open the bakup device " .
please show me,
best regard.

View 2 Replies View Related

Backup Device

Mar 15, 2004

Hi

is there a stored procedure which allows me to query if there is an existing backup device? or which gives me a listing of existing backup devices?


Thanks!

View 2 Replies View Related

SQL Backup Device

Mar 26, 2004

Hi,

request you all to clear mine one doubt that,

Can creating a backup device for sql backup reduce the backup time comparing to giving full backup path.



Cheers!!

View 1 Replies View Related

Deleting From A Backup Device

Sep 21, 2000

I have a transaction log which is backed up 5 times a day to a device.
The Transaction log is growing quite quickly in between each backup. The backup device is also growing at a much quicker rate.
realistically i would like to only keep 2 weeks worth of transaction log backups in the device.

for the transaction log backup i have tried the following transact-Sql
'Backup Log [imsv23] to [imsv23_TL_2] with RetainDays = 7, Init, NoUnload, Name = N'imsv23 TL V2', NoSkip,Stats=10,Noformat'

but due to all of the contents in the backup set not having expired the backup fails.

i need to reduce the size of the backup device. all of the backup sets have expiry dates but none of them are being deleted from device.

so my problem is 1 i need to remove the excessive backups from the device
2 i need to set up the automatic backups so that these datasets are removed when the expiry date is reached.

thanks in advance

View 3 Replies View Related

Can SQL 2000 Use A CD-RW As A Backup Device?

Jul 27, 2001

If it can, is there some special way to set it up? I can only be successful setting up a tape drive.

Thanks,
Brian

View 2 Replies View Related

Tape Backup Device Not Seen In EM

Jan 13, 2005

Hi Folks,

I have a SQL Server 7.0 with and exteranl SCSI tape device.
When I attempt to backup a database in EM the tape device is being greyed out.

I have add the backup device using sp_dumpdevice and made sure that it is in sysdevices table. It will not allow me to add this backup device from the drop down.

1. Why does EM not see this device ?
2. If I try to back this up using T-SQL will I be able to use the registared tape device.

Thanks Folks

View 2 Replies View Related

Backup Device Locations Help

Mar 23, 2004

I am a newbie in SQL Server Administration. I decided to make the move within my company that no one else wanted.

I have SQL Server 2000 running at this time; users are connecting and using it. My question I guess pertains to the backups.

I have two drives setup for data and transactions logs (D: E:)

My backups are running but backups are being sent to the d:systems datamssqlackup folder. once backups are comlete I normally copy the backups to a network share that is being backed up nightly to tape.

My question is this:

How do i create a device location under backup properties to point to a network share? i would like for the backups to go straight to a network drive so i do not have to copy the backups every morning when i come in.

View 8 Replies View Related

Restore Last Backup From A Device

Mar 29, 2004

I want to be able to take a backup device to another server and then restore the last backup file within the device.

My script creates the backup device using the filename of the file from the other server but when I do the restore it only restores the first file in the device.

How can I get it to restore the last file? In EA I can do a manual resotre and look inside the device and choose say backup number 2.

How can I do this in a script?

Thanks

View 2 Replies View Related

Trying To Create A Backup Device

May 16, 2008

Hi,
I was wondering if someone could help me. I'm having problems using backup in Enterprise Manager, the backup continually fails and points to a hardware problem. However, I have been able to backup files using different software to tape which rules out hardware.
I'm trying to create a new backup device incase the problem lies there but I receive the error 'error15061: Add device request denied. A physical device named '%s' already exists'

Any ideas?

Cheers

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved