Backing Up SQL Server

Apr 19, 2007

Hi,
I've recently created a maintenance plan, which backs up my database and transaction log. However I also have a Veritas (Backup Exec for Windows Servers) tape backup which runs at night and backs up my files. It is setup to backup the whole of my MSSQL DATA and BACKUP folders.

Today I went to do a test restore, and found that the tape backup contained nothing in the MSSQL DATA folder, but everything that was in the BACKUP folder. Is this because everything in the DATA folder is in an open state? On checking back, the tape backup has never held anything in the DATA folder. Should I be worried by this, or is it what you would expect, and is the SQL backup sufficient?

Thanks for any advice

Colin

View 2 Replies


ADVERTISEMENT

Backing Up Sql Server

Oct 4, 2007

Hey, please forgive me if my infomation source was incorrect. But a friend of mine mentioned to me he had hurd of a program, or code that will make an "install script" of your database. Basically it`ll back up all the tables on your server and if the worst case senario happens then you can run the file like an install script. Is this true? It sounds invalueable! If it isnt true, can someone tell me if it is possible to use code to create a "install script" of your own database? I am using "Microsoft SQL Server".Thanks in advance John 

View 3 Replies View Related

Backing Up Advice For Sql Server 6.5

Feb 2, 1999

hi, I have total 45 GB of data in the following servers ( 40 GB in sql server 6.5, 5GB in ftp server). both servers are in one machine(server). I want to make sure that I am doing the right thing for backup. The machine is not connected to a Lan. What is the best way to insure that my data are backed up safely?
what I am thinking of doing is to back up the database to using sql tools in the menu bar, that will backup the data to the same machine in this directory:
c:mssqlackupDBname.DAT

I will do this for all database in the sql server. Am I save to do this... I am wondering what IF the machine in which both severs are in crashed. My backup effort will be lost too. right. so what is the best way to protect my data. Do I need to buy a tape backup so I can do what I am doing Plus back up the c:mssqlackupDBname.DAT to the tape backup... I would really appreciate any suggestion in choosing any media (software/ hardware)to back up my data.

Thanks

Ali

View 4 Replies View Related

Backing Up And Restoring SQL Server

Jul 23, 2005

I want to reformat my servers harddrive and install a newer operatingsystem (Win 2003). I am running SQL Server 2000 with about 10databases. What is the best way to backup and restore SQL Server forthis so I don't lose anything.Thanks,Rick

View 1 Replies View Related

Backing Up To A Remote Server

Jul 8, 2006

I am just getting started with MS SQL and am having to learn from scratch. I have a DB running with an ISP which I need to back up to one of my local machines. I have installed MS SQL Server 2005 and also MS SQL Server Management Studio Express. Using this, I have opened a new DB on the local machine and then accessed the DB on the remote server. If I then right click on the remote DB file and select TasksBackup, I see the backup options screen. The problem is that the destination for the backup is automatically set to a folder on the remote server and I cannot figure out how to change this so that I can download to the local machine. If I click on the 'Add' button to create a new backup path, it will only offer me a view of the remote machine, not the local file structure.

The solution is probably pretty simple, but after several hours of experimentation and searching for solutions, I still can't come up with the answer. Can anyone offer some guidance please (in idiot language - I'm new to this).

View 1 Replies View Related

Help! Backing Up Sql Server 2005 Using Osql.exe

Aug 26, 2006

Hi  I am trying to make a backup of my SQL server 2005, used with Web Developer 2005 Express, in osql.exe (can't find any other way of doing it). I get the error that "under the default settings SQL server does not allow remote connections".I connect to it fine from the Web Developer 2005 and my application . I followed  another post's instructions where I enabled the TCP/IP and named pipes for "Protocols for SQLEXPRESS", but didn't work. In fact when I changed TCP/IP properties/ IP Addresses/TCP Dynamic port to nothing , and TCP Port to 1357, the server wouldn't start again !! (not doin THAT again)Regards Amanda 

View 1 Replies View Related

Backing Up SQL Server 2005 Express

Apr 22, 2007

How can I back up existing SQL Server 2005 Express tables? I'm presently developing on a 4 year old laptop which is toooo sloooow and need to transfer the tables and data to a desktop system.

View 1 Replies View Related

Backing Up A Database From MS SQL 2000 Server

Nov 1, 2004

My client is changing hosting providers. We are trying to download a full backup of our MS SQL 2000 database from the old host. We can get all of the data using the Data transfer wizard in Enterprise manager. We can get all data and structure using the Data Transfer wizard with other options. However, when we do this, all of our tables get renamed with a prefix that is our username from the old host.

So, if we have a table named customers and our MSSQL login on the old host is userA, then our table gets renamed to tableA.customers.

This won't work with our applications and stored procedures. Changing tens of thousands of lines of code is not acceptable.

Does anyone know a way we can get a full copy of the database (rules, data, structure, keys, identies, etc) without having the username prefix?

Thanks for the help!

-DAGTA

View 1 Replies View Related

Backing Up SQL Server MSDE And Express

Jun 4, 2007

We are attempting to backup using a maintenance plan a database to a network share.

The backup job works within a domain but fails within a workgroup?



Any thoughts?



thanks

View 1 Replies View Related

SQL Server Refusing Connections While Backing Up

Jul 31, 2007

Hi,

We're running SQL Server 2005 (9.00.1399.06, RTM, Standard Edition (64-bit)). A couple of times each day, all connections to the server will fail, and this behavior coincides with backup activity. What tends to happen is that after performing flawlessly for hours, SQL Server will start rejecting all connections. Over the course of the next 30 seconds or so, several hundred instances of the following error message will appear in the Application event log:

"SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems." Source: MSSQLSERVER, Category 4, Event ID 17189.

Immediately following these Error entries are Information entries that indicate some backup activity has been performed:

"Database differential changes were backed up. Database: [lots of db-specific details] ..." Source: MSSQLSERVER, Category 6, Event ID 18270.

As soon as the backups are completed, everything returns to normal and connections are once again accepted. The entire cycle takes less than a minute. Obviously, something is causing SQL Server to lock up and reject connections while it's backing up. Is there a setting that controls this, or does this behavior point to an overloaded machine?

We don't seem to be having any other performance problems at all, and there are no other Errors in the Application event log from SQL Server. If I perform a manual backup, I don't get any dropped or refused connections, even if I do it during peak query hours. So I'm stumped as to why the machine is locking up in this manner. Unfortunately there's no info in the EEMC about event ID 17189.

TIA

Shaun

View 1 Replies View Related

Backing Up Trans Logs To Win2000 Server

Jul 31, 2002

I have my SQL7 server running on NT4 server. Currently the transaction log backups are on the same server but I want to back these up to a Win2000
server in another building. When creating a Backup Device in Enterprise Manager on the NT server it cannot see the drive but not the folder I have created on the Win2000 server, even though I have shared this folder out and set the permissions. Any help would be appreciated.. Thanks

View 3 Replies View Related

MS SQL Server 2000... Error Backing Up Database

Mar 30, 2004

Hi

I am getting an error while backing up a particular database named "asset" . The error says ........

Server: Msg 3132, Level 16, State 1, Line 4
The media set for database 'Asset' has 2 family members but only 1 are provided. All members must be provided.
Server: Msg 3013, Level 16, State 1, Line 4
BACKUP DATABASE is terminating abnormally.

I have created two backup devices for this database ("asset") through enterprise manager.
AssetDMP
AssetLogDMP

I have total 9 databases out of which only this database throws error. All other database backups going fine.

Here is the query that I am using to backup the database and Log.

USE master
GO
IF EXISTS (SELECT * FROM sysdatabases WHERE name = 'Asset')
BACKUP DATABASE Asset TO AssetDMP WITH NOUNLOAD, STATS=10, INIT, SKIP
GO
IF EXISTS (SELECT * FROM sysdatabases WHERE name = 'Asset')
BACKUP LOG Asset TO AssetLogDMP WITH NOUNLOAD, STATS=10, INIT, SKIP



Please Help

Thank You / Ssg

View 8 Replies View Related

SQL 2012 :: Error When Backing Up To A Backup Server?

Jul 11, 2014

I'm trying to backup my databases to another backup server though I'm receiving the attached error.

the SQL service is logged on as "Network Service"

View 7 Replies View Related

Backing Up DPAPI Keys In Relation To SQL Server

Sep 13, 2007


Hi,
There alot of talk about Service Master and DB Master keys and the importance of backing them up seperately.
What about the DPAPI keys used to protect the Service Master keys. What procedures to I take to back those up during my database backup.
If I understand correctly, if I do a backup on one machine, and then try to restore in a different machine, I won't be able to decrypt data becuase the DPAPI keys don't "match".
This is assumming I don't use a password to protect my DB Master keys, I just rely on the service master to protect them.

Thanks for any help,

View 3 Replies View Related

HELP. Back Up Problem When Backing Up To A Mapped Drive On Another Server

Mar 20, 2002

Hi,

I have a rather odd problem that hopefully you'll be able to shed some light on.

We want to back up the databases to a hard drive held on another server so I mapped the drive in explorer to the drive then went into Enterprise manager and tried to create a backup device and it won't see the mapped drive.

I've tried mapping to my PC and I can see that via enterprise managers backup stuff (infact any PC in the office works) but it won't see any of the servers even though we can map to them and access them via windows explorer.

I've tried when logged on via sa and the windows NT administrator and still no luck. In fact no matter what I type or do it fails and keeps telling me device error or device off line which it isn't.

On our test instance of SQL Sever we can backup to other servers but not the new live version!

Any thoughts on what might cause this to happen and how to fix it?

Help much appriciated.
Thanks Helen

View 1 Replies View Related

HELP. Back Up Problem When Backing Up To A Mapped Drive On Another Server

Mar 20, 2002

Hi,

I have a rather odd problem that hopefully you'll be able to shed some light on.

We want to back up the databases to a hard drive held on another server so I mapped the drive in explorer to the drive then went into Enterprise manager and tried to create a backup device and it won't see the mapped drive.

I've tried mapping to my PC and I can see that via enterprise managers backup stuff (infact any PC in the office works) but it won't see any of the servers even though we can map to them and access them via windows explorer.

I've tried when logged on via sa and the windows NT administrator and still no luck. In fact no matter what I type or do it fails and keeps telling me device error or device off line which it isn't.

On our test instance of SQL Sever we can backup to other servers but not the new live version!

Any thoughts on what might cause this to happen and how to fix it?

Help much appriciated.
Thanks Helen

View 1 Replies View Related

Backing Up The SQL Server 2000 Database Using Tape Drives

Jun 9, 2006

Dear sir/madam,

I am from NTU, Singapore and we have a windows 2003 server edition installed on a DELL server and it also runs MS SQL server 2000 for a project of ours. We have installed a HP tape drive on the dell server and it works fine if ntbackup is used at the command prompt but then the SQL enterprise manager does not recognize the tape drive and backing up of our database is of high priority as it contains sensitive information. But the tape drive is installed properly as the device manager does not show any error and ntbackup also recognizes it. I cant seem to figure out why SQL server 2000 cannot recognize it. It would be very helpful if you could kindly guide me on this issue.

Thanking you

Regards

Lavanya Janardhanan



View 1 Replies View Related

Considerations... Backing Up IIS 6 Web Files And SQL Server 2005 Express Database

Mar 1, 2006

Anyone know of a good "free" way to back up web files and SQL Server 2005 Express Database?
I was able to use Windows Server 2003 Backup utility to back up the folder where the Databases were stored, as well as the web files, with no errors.
But I have heard a lot of discussion that you can't just simply backup SQL Server data files?
I'm wondering how sound the backup I've created is...
Any suggestions?

View 1 Replies View Related

Backing Up From Server And Restoring To Local Express - Files Not Visible

Mar 25, 2013

i wanted to test routines using my local sql server engine and thought I could backup the mdf ldf file on the true network sql server in which I am listed as a dbowner with full permissions. In fact i can add users for the at db etc.The backup allows me to browse to a local folder

with the following being the default C:Program FilesMicrosoft SQL ServerMSSQL10_50.CMS_PROJECTMSSQLBackup

i name the file and it executes properly but when i try to restore that file to my local db that path is not even visible to me.In fact when i use exploreer I cannot even find the folders after Microsoft SQL Server!I search for .bak but nothing.How can I see that folder construction in the sql browser but never in explorer -

View 2 Replies View Related

SQL Server Admin 2014 :: Backing Up To Mount Point - Perfmon Shows Zero Writes

Apr 20, 2015

Im backing up to a network directory thats actually a mount point on a different server.My backup was slower than usual so i opened up perfmon to have a look.

When selecting the mount point from the Logical Disks section in perfmon i can see that writes/sec & write bytes/sec both show zero for a long period of time, even though the backup percent complete is increasing.Then all of a sudden the writes to the network share jump massively.

Is there some caching mechanism for backups in sql where during a backup data is only flushed to the disk periodically during backup?

View 1 Replies View Related

Backing Up SQL DB

Aug 15, 2006

We're trying to create a .bak file to send it to our site's admin to restore it on the
server:
1. When I try to do that get this error:http://www.radiorient.net/errors/export_sql.gif
Why is that? and how can I fix it?
2. Should we add both files of the db (.MDF, and .LDF) or only the .MDF file?
Can please someone help me with this, Thanx.

View 2 Replies View Related

Backing Up A MDF

Nov 10, 2007

 I plan on using a database file for my site, how would I back it up if I were to make changes to my site? 

View 5 Replies View Related

BACKING UP SQL 7.0

Sep 2, 1999

I just got SQL 7.0 and was curious how other environments run their backup. I know ArcServe has a product that backs up open SQL databases and not sure how reliable this product was. Any thoughts would be appreciated .. thanks.

View 3 Replies View Related

Backing Up MS SQL?

Jul 20, 2005

HiI'm hoping that some could point me in the right direction for "bestpractice" in:1) securely backing up a complete sql7 and 2000 server containing manydatabases.2) backing up an individual database3) Securing the transaction on the hour as a mile stone to return to in theevent of error or system failure.ThanksMark

View 5 Replies View Related

Backing Up

May 20, 2007

I always do a quick backup of my project using Developer's Backup before proceeding.

View 1 Replies View Related

Please Help....backing Up Trn Logs

Aug 26, 2002

Scenario:

I have August22 full backup and August22 and August23 transactions log backups . I want to get the August23 and August23 full backup. So I performed a restore backup with August22 full backup and all the August22 trn backups. Then I backed up giving it August23 name and repeated the process with the August23 trn backups. But, I get an error saying that the transactions haven't been rolled foward far enough. But, I am not missing any trns! I will really be grateful if anyone would help.
thanks.

View 1 Replies View Related

Backing Up DTS Packages

Jul 13, 2000

Does anyone know how we can backup DTS packages?

View 2 Replies View Related

Backing Up On A Different Machine

Aug 7, 2000

Hi,

i want to take a backup a database which is on a different machine to my machine.Iam trying to give unc naming conventions i.e backup to //servername/sharename/file.bak but its not working.iam getting an error saying device error or device offline-access denied.

Anyone could tell me how to do it step by step plz.


Thanks.

View 2 Replies View Related

Backing Up A Database In SQL 7.0

Mar 3, 2000

When backing up a database in MS SQL 7.0, there is a window that appears in the destination section of the backup window. In this window is where the filename appears that the backup will proceed to and to the right of this window are "add", "remove" and "contents" buttons.

If there are multiple names in this window, will the entire backup go to both files or does it split the backup between the two filenames.

View 1 Replies View Related

Backing Up DTS Packages

Mar 12, 2001

TO backup a DTS package, does backing up MSDB take care of this or do the files need to be individually backed up?

View 1 Replies View Related

Backing Up Tables

Mar 10, 2004

I use SQL Server 2000 and I create scripts on a daily basis to do the following

1. Rename a table
2. Create table with original name and add new field
3. Copy data from renamed table to new table
4. Build indexes
-----------------------------------------
execute sp_rename ORIGINAL, OLD
GO

CREATE TABLE [dbo].[ORIGINAL] (
[A] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[B] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[C] [int] NOT NULL ,
[Notes] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

INSERT INTO ORIGINAL (A, B, NOTES)
SELECT A, B, NOTES
FROM OLD

CREATE CLUSTERED INDEX [ORIGINAL_A_B] ON [dbo].[ORIGINAL]([A], [B] DESC ) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
-----------------------------------------

ON A TABLE WITH 100,000 RECORDS THIS KIND OF SCRIPT TAKES A LONG TIME TO DO THE INSERT/SELECT PART

I WOULD USE ALTER/ADD TO UPDATE THE TABLES, BUT MY SUPERIOR INSISTS THAT NOT HAVING TEXT FIELDS AS THE LAST FIELD IN THE TABLE WILL CAUSE QUERKY PROBLEMS WITH HIS SQL STATEMENTS
DOES ANYONE HAVE ANY KNOWLEDGE THAT THIS COULD BE TRUE?

IF SO,
DOES ANYONE HAVE ANY IDEAS FOR DOING THIS SAME PROCESS TO ADD A NEW FIELD (C) BEFORE THE FINAL FIELD (NOTES - TEXT FIELD), AND BACKUP THE TABLE BUT WITHOUT IT TAKING SUCH A LONG TIME ON THE INSERT/SELECT PART?

Forgive me if I'm asking a lot, but I'm lost and these scripts take way too long for what seems like such a simple task.

Thanks,
Mitch

View 2 Replies View Related

Backing Up Database

May 6, 2004

Here is the situation, I have a web application (asp.net/vb.net) with ms sql 2000 as the database. I have two database server. I would like to backup database 1 with database 2. I would like to do it at intervals and through code. If anyone can give me some ideas on how to do this or any research material, please do.

Thanks

View 2 Replies View Related

Backing Up Database

Feb 20, 2007

Sorry this is so trivial, but I don't work with SQL Server too much. I just want to back up a table in one of my databases. I'm using SQL Server 2005, the management studio. Can someone walk me through how to back up a table? Thanks!

View 1 Replies View Related







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