SQL Server Backup

FULL BACKUP taken by SQLExecDirect function works, but backup is not taken why?

I try to backup SQL server database using ODBC native client apis. One weird error occurs. When I run, SQLExecDirect(stmt, "BACKUP DATABASE dbname TO DISK='C:TESTBK.BAK' WITH FORMAT ", sql_nts ) There are no errors during runtime, and message shows backup taken . But it is not seen innthe specified...

How to export/ import userschema in SQL server 2005?

To export userschema in oracle, we can use expdp and impdp commands. Do we have any commands to export/ import userschema in SQL server 2005? Also, How to export all the tables to filesystem? Using SQL management server studio there is an option to export 1 table at a time to a file.      

Techniques for storing SQL Server data online and for backing up the server

For a banking application, I would like to keep 10 years worth of data using SQL Server. I would like to keep two years online and backup the other eight years. What are some techniques to do this?   Software/Hardware used: SQL Server

SQL Database User

Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql...

SQL Server Transaction Logs

If I change the recovery model on the primary database from full to simple and then change the primary database back to full again. Would that break the log chain? It seems the log shipping breaks after we do that. Software/Hardware used: SQL Server 2005

sql server 2000 how can i make backup 4 file only and restore

how can i make backup 4 file only and restore

Backup failing

Hi Mrdenny, I have as GIG. I have a Database Full Backup Maintenance Plan that fails to execute, and I get the same error as GIG's. I checked my disk and I think there is enough free space available (471GB). What could be causing the full backup to fail? Please help! Thanks in advance.

Error backing up with SAP transaction DB13

The following error message occurs when I attempt to backup with SAP transaction DB13: ***************************** SQL Job information ****************************** Jobname: SAP CCMS Full DB Backup of master,RPD [20090620094326-6-094326] Type: TSQL DB-Name: RPD For Run: ...

Software to automate backups for SQL Server 2008 databases

I am running SQL Server 2008 and I know how to create backups of this data manually using SQL managment studio but we are looking for a way to automate the process. Does anyone know of a product that can be utilized to do this? Or a way the managment studio can be set up to do this? It's not...

Backing up SQL Server 2008 databases to a tape drive

I am running Sql Server 2008 and I need to know how to make backups of the database onto a tape drive. How do I do this?

MS SQL SERVER (BKUPEXEC) Services wont start

Hi ALL, Background: Windows 2003 Server returned the error missing or corrupted file after the server was found OFF due to possible power problems (Server is on a UPS). Ran a CHKDSK on the server and it fixed the missing or corrupted file problem and server now up and running. Is seems that my...

Transaction Log - SQL Server 2005

How do i find out what transaction log file was last applied to a database?

SQL Server backup would not terminate

I tried to stop the backup which was already fired through job schedule,but it did't stop. Then I stop the sql serveragent but it also not abled to stop the backup. The backup size was 100GB. Could you please give me the reason and solution of it.

How to restore SQL Server 2000 backup file

how to restore sql 2000 backup file

Backing up virtual SQL servers

The following question was recently submitted by a user via e-mail: I’m using ArcServe to back up our virtual machines, and I’m wondering what other tools people are using to back up their virtual SQL servers?

Taking a backup of a running site on a SQL Server

How can you take a backup of a running site on a SQL Server?

SQL Server data purging

I hv a trans tbl and want to keep the records to be purged on Tape/Media and read the data from there whenever required? I want to know, Is that possible to read data from the tape ? if so, then how to do it, neee help

SQL Server 2005 SP2 backup failing

This is my first post and thanks in advance for any replies. I have a backup that failed midway (about 120G of 230G) into the backup twice in the last 2 weeks. Each time, the first error that gets reported in the Application log has been, "BackupMedium::ReportIoError: write failure on backup...

SQL Server 2008 Export data problem

Hi I'm trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy. Firstly I created a new empty db on the local machine. Then I scripted...

SQL Server 2005 backup

how to take backup of live site