Backup Devices Vs Files In SQL7

Jun 16, 2001

If I'm not mistaken, we can create a backup device OR backup files in SQL7. Can someone tell me which one is better?

View 1 Replies


ADVERTISEMENT

Backup Devices

Nov 4, 2000

hi, I usually back up the database to a file within the sql server box. then use a tape backup to back up the whole directory of the sql server in the d: drive.

Is this right way to do or there is a better way ?

Ahmed

View 1 Replies View Related

Moving Backup Devices

Jul 28, 2000

I have taken backups and the backup devices are stored in C: drive and now i want them to be moved onto the other drive.So how can i do it without creating new devices and scheduling them again.

Any help would be appreciated.

Thanks,
Kris

View 2 Replies View Related

Initialising Backup Devices

Aug 11, 2000

i need to initialise the backup devices as the the backup files have grown so big thats its occupy hard drive space , each device is for @ day for all databse we use , what do i do

thanks


safac

View 1 Replies View Related

Help Scripting Backup Devices

Jun 11, 2004

Hi guys

I am relatively new to SQL Server admin and I have been handed a task of creating backup devices for a particular SQL Server which has 204 databases.

Rather than go through and create Full, Incramental and Transaction Log backup devices for each database is ther anyway of doing the following

Create a script to go through and for each database name in 'sysdatabases'

create a folder e.g sqldataackup\%databasename%

and within each folder create a backup device called

%databasename%_full
%databasename%_inc
%databasename%_log

Also all these databases are running in 'Simple' recovery mode so obviously I need to change this to 'Full' to enable incramental and log backups - is this possible using the same script.

Hope someone can help as the thought of doing all of this individually for each database scares me silly!!! :)

Thanks in advance for any help

Hanley

View 5 Replies View Related

Backup / Restore Devices

Sep 28, 2006

Hi,

I am using EMS SQL Manager for SQL Server (www.sqlmanager.net). I am trying to learn how to do backups of my database.

I am up to this step -> http://www.sqlmanager.net/products/mssql/manager/documentation/hs21640.html

I don't think I actually understand what a device is, how it's created, where it resides, etc. I would like to backup my remote datasource to my local computer's harddrive.

Can someone please explain how this 'device' works and how I should set up?

Thank you so much for any help :-)

jo

View 9 Replies View Related

EM Backup Devices Not Showing History..

Jan 12, 2000

Hello,
I am using EM to administer SQL 6.5 SP5a and have a few dBs that do not show backup history by expanding the backup device. The server is regestered as SA and MSDB does contain the the correct data in the sysbackuphistory table. MSDB DBCCs OK and other dBs show history. I manage multiple SQL 6.5 servers but this is the first time I've seen this and can find no info in the various KBs or NGs..
Anyone have any clues?
Thanks,
Jack

View 3 Replies View Related

Backup Striping To Multiple Devices

Mar 29, 2004

Hello--

I am trying to backup a VLDB (800+gig) to multiple devices. I am using 4 disk drives. Assuming all devices have the same performance, should the 4 devices fill equally? (IE 200gig per drive) If so, what would might happen if one of the 4 drives only has 100 gig free with the other 3 having 300 gig free each?

Thanks for the help--
Jeff

View 2 Replies View Related

SQL SERVER BACKUP Problem In Different DEVICES

Jul 23, 2005

Hi there,I need to take a backup with the following scanerio in mind:At T1 I take the FULL BACK UP of the database called BACK_1_FULL.BACK inc:Then at T2 I would like to take only the differential BACKUP of theTransaction log called BACK_1_TRANSLOG.BACK and at T3 I would like totakeonly the differential BACKUP of the Transaction log calledBACK_2_TRANSLOG.BACK. At T4 my system fails and I need to bring thedatabaseto a point where my T3 state is in. I tried taking the backups in DEVICEbutI always get an error from SQL Server Enterprise manager such asVolume on Device 'Device2' is not part of a family media set. BACKUPWITH NOFORMAT can be used to form a new media set. BACKUP LOG is terminatingabnormally.If someone can give suggestions on how to backup and restore in thissituation it will be really helpful.ThanksJohn*** Sent via Developersdex http://www.developersdex.com ***

View 1 Replies View Related

Restore A Backup Into A New Database With Different Path On The Devices

Mar 11, 1999

Hi, I've to restore a bk into a new DB, because the old one has a lot of devices created on different places and phisical disks.
Im not sure to do that, cause Ive heard some problems with this action.

The old Db has 10 devices of data and 10 devices of log, and I want to create only one device of data (sum of all the data devices) and only one device of log (sum of all log devices)
Is it possible or not?

Tnx a lot!

View 2 Replies View Related

DB Engine :: Restore Failed With Very Large Backup Devices

Jul 1, 2015

I have a database size of 9.8TB and I backup it to 30 backup devices. Each one has 110GB after backup compression.I tried to restore these files to standby server via 100MbE network but it always failed. My colleague told me this never happen before and I said yes because I have done this before a lot of times when backup devices are significantly smaller.He said the only way is to copy backup files locally and restore locally. But I am trying another method, I create more: 64(maximum) backup devices and try to restore via network again.SQL server version is Microsoft SQL Server 2012 (SP1)

- 11.0.3401.0 (X64)   Jan  9 2014 13:22:15   Copyright (c) Microsoft Corporation 
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.1 <X64> (Build 7601:
Service Pack 1) .

---  error message ---
5 percent processed.
10 percent processed.
15 percent processed.

[code]....

RESTORE DATABASE is terminating abnormally.

View 11 Replies View Related

Backup Error:Set Property Devices To Accomplish This Action.

Aug 20, 2007

I am getting an error, "Set property Devices to accomplish this action." when doing a backup with SQL Server 2005 Express when I try to do a full (or Differential) backup through the SQL Server Management Studio. I'm using the backup defaults in the GUI and was able to back up the database a couple of days ago without any problem. Today (second time) it just comes up with this error and I have been able to find anything that talks about what it might be.

I tired to look at the script by using the "Script action to new query, file, clipboard, etc." but it fails before it creates the script in any destination. I've rebooted the server and that didn't help.

I found one similar post on this forum but it had no resolution. Any direction on this problem would be greatly appreciated.

Thank you,

Steve

View 10 Replies View Related

Recovery :: Select Backup Devices Hangs After Clicking Add Button

Oct 18, 2015

I'm trying to restore a database using SSMS GUI. In "Select backup devices" window if I click the Add button there the window and the whole process hangs like it will never work.

I tried to clear backup history, but that didn't solve it.

I tried with a couple of other databases, but same thing. It was working fine!

View 9 Replies View Related

SQL7 Backup

Nov 17, 2000

I need to backup my sql7 through the network share.
I have two servers both have SQL7 and only one has a backup tape drive (which is my production database). I want to be able to backup to the tape and to the a share drive on the second server. The backup to the tape work fine but if I want to backup to share drive locate to the second server I can't see the share where I want to put the backup. Do you Know what I am doing wrong ?

Thanks.
Mtraore.

View 1 Replies View Related

SQL7 Backup

Nov 17, 2000

I need to backup my sql7 through the network share.
I have two servers both have SQL7 and only one has a backup tape drive (which is my production database). I want to be able to backup to the tape and to the a share drive on the second server. The backup to the tape work fine but if I want to backup to share drive locate to the second server I can't see the share where I want to put the backup. Do you Know what I am doing wrong ?

Thanks.
Mtraore.

View 2 Replies View Related

Removing Secondary DB Files - SQL7 To SQL2K

Feb 24, 2003

I'm converting DBs from SQL7 to SQL2K; the previous owner & server issues had created secondary data and/or log files. The size of the databases, and the configuration of the new server, do not warrant those secondary files. In restoring the databases from SQL7 to SQL2K, either by detach/copy/attach or backup/restore, is there a method for deleting the secondary files without, of course, losing any data?!

TIA,

Al

View 3 Replies View Related

SQL7 + Stored Proc&#39;s = Files [Persistant Recordsets]

Oct 10, 2000

Hi,

I was wondering, is there any way to have a stored procedure write to a file its resultant recordset?

i.e. I have this SP which fires a query, this in turn returns a single row recordset that I need to have written to a file. I realise this could easily be facilitated using an ADO client, however, can it be done by the backend i.e. the SQL7 & SP itself, directly?

I hope you can help me here! thanks for your time!
Cheers
Gaurav

View 2 Replies View Related

Restoring SQL2k Backup In SQL7.0

May 10, 2001

Can we restore a SQL 2k Backup in SQL Server 7.0 database?

Will there be any issues on it?

View 1 Replies View Related

Restoring SQL7 Database From SQL 6.5 Backup

Mar 29, 2000

I am trying to replicate a client's environment on my home development machine in order to develop some reports. At the client (SQL 6.5) I did a complete backup to a .dat file. How can I restore from this file into my home (SQL 7) server to create a duplicate database?? I tried restoring from a device, specified the file, but I get an "not a valid tape format ....." error. Help!

View 5 Replies View Related

Backup Quits Working After Upgrade From SQL7 To SQL 2K

Apr 15, 2002

I had a number of jobs which were backing up system and user databases under SQL 7 using SQL ServerAgent. Over the weekend I upgraded SQL 7 to SQL 2K.

All backups work except for one, which gets the following error message: Executed as user: SANDIEGOSvcSQLServer. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

As best as I know SQLSTATE 42000 is an ODBC message indicating a syntax violation or an access violation. I have recreated the maintenance plan in an attempt to rule out a syntax violation. During the upgrade process I did not change the account under which SQL Server Agent runs, so it seems like it should not be an access violation.

Any ideas would be appreciated!!!

Thanks Gary Andrews Andrews_gary_w@solarturbines.com

View 1 Replies View Related

SQL7: Restoring Backup, Drastic Change

Apr 4, 2007

Once a week a query is run against my SQL7 database. One month has passed and a backup of the database was restored. The database was restored as a seperate database from the active one.

The very same query was run against the backup, the results of the query were drastically different. What is worse the very same pattern that developed in the restored backup now seems to be affecting the active database.



Would restoring a database cause this sort of issue?

View 1 Replies View Related

SQL 2012 :: FOR FILES Command To Delete Old Backup Files On Remote Server?

Feb 24, 2015

I have the need to delete old backup files via TSQL job. Found this solution online:

PushD "
emoteservershareDIFF" &&(
forfiles -m *DIFF*.sqb -d -1 -c "cmd /c del /q @path"
) & PopD

It works remotely if I run it via command prompt. But when I add this to a TSQL job on my remote SQL instance, it runs without deleting anything. What I'm missing?

View 6 Replies View Related

SQL Server 2008 :: Count Number Of Backup Files Deleted From A Default Backup Location

Mar 13, 2015

I've written a custom script to delete backup files from location. But unable to modify now to count the number of files are deleted. How to modify the script...

/* Script to delete older than N days backup from a specific directory */

USE [db_admin]
GO
IF OBJECT_ID('usp_DeleteBackup', 'P') IS NOT NULL
DROP PROC usp_DeleteBackup
GO

[Code] .....

View 2 Replies View Related

Is There A MS SQL Backup Tool That Will Zip Or Compress The Backup Files?

Feb 27, 2007

Currently we use a SQL maintenance plan to do a full backup of all our databases daily (about 40 databases on our production server).  As you can imagine, this eats up disk space quickly so currently we manually zip the backup files and/or move them to an archive drive.  I considered writing an application to walk through the backup folder structure and zip any .bak file it finds, but I know there are some third party tools out there that will backup/restore a MS SQL database.
I was wondering if any of these also zip the backups once they are created.  Any recommendations or suggestions are welcome.
 

View 1 Replies View Related

SQL 2012 :: Missing Other Backup Files Backup

Nov 3, 2014

I scheduled automatic backup process but its only showing backup of the only one .sql file in the backup folder. Other created .sql files are not backed up. Why is it so?

View 5 Replies View Related

Backup Db To Split Backup Files

Apr 12, 2007

Hi everyone,

I want to do sql db backup.But how can I backup db to split backup files? The reason I want to split the backup file is becasue single file size is too big and I want to write to dvd.

any idea or scripts?

cheers

View 1 Replies View Related

Backup Files

Apr 19, 2006

hello! can you take a look at my question?
We use ARCServe to backup exchange server file (priv1.stm and priv1.edb) every night. When I select both of the files and start to back up using ARCServe. It showed me that Backup Operation Successful.

When I check the files, it didn’t backup both of the files. I don’t know why. Do you know how to backup these two files?

Many thanks.

View 1 Replies View Related

Backup SQL Files

May 6, 2006

Hi,We are about to install MSSQL Server 2000, on a Windows XP HomeMachine. However, we have servers we could set routine backups of filesto be done to. What what be the best way of doing this?Is there functionality in SQL Server 2000, where we can say dump alldata definitions, accounts, and data to files on this drive at regularintervals?What other suggestions do you have apart from obviously the usual RAID,and Tape Drive stuff?ThanksDavid

View 2 Replies View Related

Backup Files

Nov 20, 2007

I am going to move to a different host. Can I get back up files of my SQLServer database (from the host) and use those to set up on the new host? Andif so, is that what I should be asking for - backup files? Someone told methere should be 2 files.Thanks

View 1 Replies View Related

BackUp SQLEXPRESS Mdf Files

Sep 28, 2006

Hi All,I searched the archives but I could not find any useful stuff for me.I can backup a database on SQLExpress like USE masterEXEC sp_addumpdevice 'disk', 'Store_1', 'c:Store_1.dat'BACKUP DATABASE Store TO Store_1Here is my problem: If I use logins,roles etc. in an application automatically a mdf file is created. Or I can create a new sql database.  SQLExpress dynamically use the mdf file when connection string defined. This mdf file is not defined as a database on SQLExpress. Because SQLExpress has not a gui, I cannot see the registered database.  How can I backup any sqlexpress mdf file without deattaching or attaching?Thanks

View 2 Replies View Related

Backup Database To CSV Files

Nov 1, 2006

HiWhat is the easiest option for Exporting ALL of my SQL Server tables into a CSV file (either separate CSV files for each table or one big file with all the table columns and data) ???I just want to Backup my SQL Server database like we backup MySQL database using phpMyAdmin. Unfortunately, my SQL hosting company does not allow backups for free.Thanks for help

View 1 Replies View Related

Database Backup Using .LDF && .MDF Files

Apr 12, 2006

Hi,
I am developing a tool that takes snapshot of a particular database.
By snapshot I mean, attaching the .LDF & .MDF files.
Would  you please let me know how to access these files & take a backup of the same.
And also how to restore them back. (using c# programming)
Thanks,
Archana A.A.
 

View 1 Replies View Related

Size Of Backup Files

Jun 25, 1999

I need to know how big SQL Server 7 backup files are in comparison to the database size. For example if I have a database that is 300 Mb and I do a complete backup to disk with SQL Server 7 will the backup file be about 300 Mb?

Thanks,

Mike

View 2 Replies View Related







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