0
votes
2answers
213 views

Server failed, can I retrieve my database from the my hard disk?

I have an old server running Windows Server 2003 R2. Windows got corrupted due to an improper shutdown. I attempted to repair the Windows installation, but it made things worse (it gets to the ...
1
vote
1answer
1k views

SQL 2008 Backups to UNC Share Failing 0xC002F210

This problem is driving me NUTS!! We take backups of all of our production databases to a network share, which are then backed up to tape nightly. 8pm Mon-Fri - Full backup, followed by log backup ...
0
votes
2answers
65 views

Moving database to new server

I'm restoring a backup of a production database to a new server. The new server also hosts the application which makes use of the database. As such I'd like to use the same user/pass combination to ...
1
vote
1answer
187 views

Backing up SQL backups on a network share

Currently I have Maintenance Plans configured to backup SQL Server databases to local drives, then the files are picked up by Commvault nightly, and my SQL server maintenance plan deletes the backup ...
0
votes
1answer
252 views

MSSQL techniques to archive-backup content

We are now moving from a MySQL to a MSSQL 2008R2 database. As the project is a web application that we need to be able to scale well, we need to rework the way the DB handles data. We have 3 separate ...
1
vote
1answer
35 views

Individual Customer Backup from Multi Customer DB

We have a multi customer database, that's about 95gb in size. One of the customers is requesting a monthly backup of their data. We have a script that strips out all records from all tables that are ...
0
votes
3answers
76 views

How to warehouse data that is not needed from MS SQL server

I have been asked to truncate a large table in MS SQL Server 2008. The data is not needed but might be needed once every two years. It will NEVER have to be changed, only viewed. The question is, ...
2
votes
1answer
403 views

Cleanup Backup Files without xp_cmdshell or maintenance plans

Background: We've got a backup script which needs xp_cmdshell to run. I decided that on new servers, we are not going to enable xp_cmdshell. I enabled xp_cmdshell when the job starts and turn it ...
1
vote
3answers
3k views

Backup SQL Server DB to a remote drive

I am trying to backup a SQL Server database to another drive letter located on another network on another domain. The location has already been mapped to Z:\ and corresponds to \\10.98.76.6\Backups\. ...
3
votes
3answers
651 views

SQL Server transaction log BACKUPS are very large

In SQL Server 2008 R2 I have a database that has full backups nightly and transaction log backups every ten minutes. The database is in full recovery model. The problem is that the backup files for ...
0
votes
1answer
73 views

Server restarted when I take database backup in SQL Server 2008?

I have 10 databases in my SQL Server 2008. If I take a database backup, 8 databases are working just fine. When I take database backup for the remaining two, at 50% of backup of process, the server ...
1
vote
0answers
1k views

How do deal with SQL Server transaction log corruption

We had a failure with our SQL Server log shipping job. sp_readerrorlog reported: Backup detected log corruption in database X. Context is Bad Middle Sector. LogFile: 2 'D:\Database\X_log.MDF' VLF ...
2
votes
1answer
184 views

Creating a small .bak file without indexes or excessive log

I recently was asked to ship a .bak file of our database to a client, and through reindexing all tables with a 100% fill factor (to make sure there were no empty slots), and resizing the transaction ...
2
votes
1answer
804 views

How to backup/restore excluding filestream varbinary in SQL Server 2008?

There is an application used in a production site that uses SQL Server 2008 as its DBMS. The database schema uses Filestream Varbinary to save binary data on the filesystem instead of directly into ...
1
vote
1answer
127 views

Database backup using sql management studio 2008

I want to retrieve a script for a database that will include operations of creating database, creating tables, and insert all data. How can I achieve this using management studio 2008 please. I have ...
1
vote
3answers
196 views

basics of SQL Server 2008 backups

We don't have a DBA and I have to do backups. We have only one database that is 3gb (the others are less than 100mb). The 3gb database is write-heavy, and has very important data. I set up daily ...
1
vote
1answer
394 views

How to schedule backups in SQL Server 2008 Web Edition?

I have a SQL Server 2008 Web Edition and I used the Management > Management Plans > Wizrd to schedule the backup of all my databases. I executred the task to test it and I get this error: ...
3
votes
3answers
1k views

SQL Server Backup retention policy

I need to backup database in full recovery mode with a condition as: 1. Backup database, only when space is available for backup operation and Backup retention policy must be like expect last two days ...
0
votes
2answers
336 views

Running sql server 2000 backup file on sql server 2008

I restored sql server 2000 .bak file to sql server 2008 by --RESTORE FILELISTONLY --FROM DISK = 'D:\DBHarshal\full backup august 6.BAK' --ALTER DATABASE EPICSms --SET SINGLE_USER WITH --ROLLBACK ...