1
vote
3answers
84 views

SQL Backup Is Taking All My Hard Drive Space

I have a job that I run every day to backup my SQL database. I just bought a band new server and was going to transfer the database backup over to the new serer and restore it. Our database isn't as ...
0
votes
2answers
72 views

Possible to take a backup of SQL Server 2012 DB and restore on 2008?

I want to take a backup of SQL 2012 and restore on 2008, is that possible ? I have this options which I can't change on DB. Thank you
0
votes
1answer
30 views

Backing PDF files and SQL server DB

I have my own Windows Server an Asp.Net application hosted live. The application allows users to upload CV PDF files and I have the DB also on that server. Which steps should I take to ensure that all ...
1
vote
4answers
208 views

Sql Server Backup Compatibility - 2008 with 2005

I'm hoping to restore a backup from SQL Server 2008 into a Sql Server 2005 instance. Is there a way to have Sql 2008 back up in a format that 2005 will understand?
1
vote
2answers
80 views

SQL Server 2008 - Service account for backups

I am setting up a backup software to backup all the databases on my MS SQL Server 2008. I want to configure a service account with administrator rights on the database. The service account have ...
1
vote
1answer
923 views

Backup SQL Server over Network share

I have a SQL 08 Standard box that I would like to use a Maintenance Plan to backup a database over a network share? Is this possible as the GUI won't let me do that? It tells me it can't find the ...
1
vote
1answer
186 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 ...
1
vote
2answers
593 views

SQL and Shadow Protect Server

Rolling out a Server2008R2 box with SQL2008R2 on it to trial some new payroll software. I have ShadowProtect virtual licences for my VM's and this box will get one. My question is: What is the best ...
1
vote
1answer
214 views

Creating a clone of a SQL Server database via backup/restore

So I'm trying to 'clone' a SQL Server database by making a backup of the template, then restoring it to the new name. However, there's either something I'm missing or something I don't understand ...
0
votes
2answers
64 views

SQL server backups - backwards situation

Hi I'd like to know if it seems feasible to do things in this manner. We have several application servers (a web server for intranet applications, a couple of different app servers). Each server is ...
4
votes
1answer
298 views

How can I backup / restore my Sql Server 2008 Database?

I have a database that is around .. 20ish Gig. I need to (manually*) back up this database, 7zip the backup and then DOWNLOAD this backup from my server to my desktop. (Rinse, repeat sorta often). ...
3
votes
3answers
648 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 ...
2
votes
1answer
867 views

How can I create a database backup replacing the previously created backup file?

If I backup my SQL Server 2008 R2 database with the following command set @BackupFileName = N'C:\backup\Production-db.BAK' BACKUP DATABASE [Production-db] TO DISK = @BackupFileName and run the ...
1
vote
1answer
592 views

SQL Server backup jobs run twice, but appears to be scheduled once

I have a scheduled backup that should run once per day, but runs twice. I've scheduled the job to run at 6:30 AM, daily. If I view the log of that maintenance plan, I can see that it ran today at ...
0
votes
1answer
73 views

How do I backup a sql server 2008 database snapshot?

How do I backup a database snapshot, so I can restore it as another database (on same or different server?) We do not wish to roll back to the snapshot, as we need both versions of the database ...
1
vote
1answer
742 views

Restore SQL 2008 database fails with error on page xxx:xxx

This is the situation: Got a full backup (.bak file) of a SQL 2008 database, with partitions. The .bak file is 100gb. I need to restore this database on a different server, to a new database. ...
1
vote
1answer
167 views

image backup of sql server best practices?

I have a MS Sql server 2008 SP1 running on a Windows server 2008 SP1, I would like to get these upgraded to the latest service packs. Specifically we are seeing performance issues related to "Full ...
2
votes
2answers
89 views

Why isn't my SQL Server 08 Maintenance plan running at all?

I have this maintenance plan scheduled on my SQL Server 08... however, it never runs! It's been setup for 2 weeks now and I have not seen a single backup created, what am I doing wrong? How do I get ...
1
vote
1answer
80 views

SQL Server 2008: Is it possible to store differential backups in a separate files?

We're moving some of our applications to a new hosting provider and we want to make it seamless for our users. Nonetheless, we have big databases and we've got to move about 48GB of data. Our ...
1
vote
3answers
200 views

T-SQL query to schedule the back-up by using Transactional logs!sql server 2008

Hello i am new to sql server and i don't know any thing about backing up database using tsql i am trying to find out the procedure to do following but unsuccessful. T-SQL query to schedule the ...
2
votes
2answers
5k views

Can SQL Server 2008 allow you to backup to a Mapped Network Drive?

My SQL Server 2008 R2 has a mapped network drive (called Y:/) which reconnects after a reboot (I just checked this). When I try to backup a Database (TASKS -> BACKUP). The network drive Y: is not ...
2
votes
4answers
722 views

Backing up a SQL Server 2008 R2 Database without stored procedures

Is it possible to back up a SQL Server database, but only back up the Table structures and content (i.e. not include the stored procedures, views etc?) The scenario: We have a data centre hosted ...
0
votes
2answers
571 views

SQL Server 2008 database Backup

today I was trying to restore a database with a backup I had made previously on another computer, however I kept getting the following error message: the media loaded on "filepath" is formatted to ...
1
vote
1answer
379 views

SQL Server VSS Writer, Hyper-V and SQL Server 2008 backups

I have a virtual server running SQL Server 2008 R2. On the server I have configured two maintenance plans, one that takes differential backups every day except Saturday and a job that takes full ...
0
votes
6answers
285 views

Nice tool that will backup databases & logs and truncate logs?

Does anyone know of a nice tool that can be scheduled to backup databases & logs and truncate logs? Is use SQL Server 2008 Web Edition
2
votes
2answers
239 views

How do I restore a SQL Server database from last night's full backup and the active transaction log file?

I have been told that it's good practise to keep your SQL Server data files and log files on physically separate disks, because it'll allow you to recover your data to the point of failure if the data ...
1
vote
1answer
137 views

Maintenance window and recovery for a large database

One of our teams is developing a database that will be somewhat large (~500GB) and grow from there (I know 500 Gigs may seem small to many of you, but it will be one of the larger databases in our ...
0
votes
4answers
181 views

Shrinking Transaction log?

Why it is not recommended to shrink transaction log?
1
vote
4answers
67 views

Taking backups into the same disks as datafiles?

Our people who are managing databases (I can't call them DBA's because of the lack of DBA skills) are planning to take backups into the same physical disks as the database data (.mdf) files. Then all ...
0
votes
1answer
110 views

SQL Server 2008 Backup not increasing FreeSpace

OK so I've seen tons of information around about shrinking and free space and similar, but what I've not been able to see is just the basics for SQL Server 2008 on free space in the logfile. I was ...
0
votes
3answers
113 views

sql server 2008: what should the backup plan be for the master db?

we have only like 4 databases on this server. one of them is very crucial. i would like to know what should we do regarding backups for the master db? we dont really do many "master" type of ...
0
votes
2answers
122 views

sql server 2008: should i be running differential or transactional logs or both HELP!

i have two databases: this one was set up by a third party and they do not allow us to change the database to full recovery. so it is my understanding that if a database is in simple mode, then the ...
0
votes
1answer
162 views

How to backup an Sql Server on the “Cloud”

We are a small company and have the chance to move our Sql Server that we host in our office to the "Cloud". In this case the Cloud means the server would be running on a virtual machine at another ...
2
votes
1answer
341 views

Does the full backup truncate transaction log?

Does the transaction log get truncated when I take a full backup using command BACKUP DATABASE AdventureWorks TO Adventurewks GO Or do I have to take a log backup separately? BACKUP LOG ...
2
votes
3answers
4k views

How to restore a SQL Server database and shrink its files at the same time?

Let's say I have a SQL Server database whose data files have been created with an initial size of 100 GB, but it only contains 10 GB of data. A database backup will then be only 10 GB in size. I want ...
0
votes
3answers
231 views

Which Raid to store SQL backup files?

Following is my current SQL Server raid configuration: Raid1 with log files ~ 500GB Raid10 with data files ~ 1TB I would like to keep 3 day worth of daily full backup and hourly transaction log ...
1
vote
2answers
2k views

How to schedule a database backup operation by using SQL Server Management Studio in SQL Server 2008R2?

I'm having difficulties to setup a daily backup schedule in SSMS 2008 R2 Developer Edition. This is exactly what I'm trying to achieve: My SSMS connect to my DB (remotely), which located at some ...
1
vote
2answers
473 views

SQL Server 2008 Maintenance Plans — New DB in Full/Diff Cycle

I have a MS SQL 2008 database backup maintenance plan that does a Full backup and then two differential backups throughout the day. If a new database has been created the differential chokes because ...
1
vote
3answers
519 views

Trigger Powershell Command to Copy SQL Backups to Network Drive

I've got two servers on a workgroup and I need to transfer my SQL Server 2008 Backups from the local drive of one to a network drive on another. Ideally, I'd like to have SQL call the Powershell ...
2
votes
3answers
4k views

SQL Server 2008 Database 250GB on a 250GB drive

Started a new job and there is a 2008 sql database that is 250gb in size. The developers insist that the size is about right. THe problem is that the 250gb MDF file is sitting on a 250GB drive. I ...
2
votes
1answer
25 views

How to ensure dbs are all in sync when restored?

In large server environments, how do you handle the issue of backing up SQL Server dbs which may not be in sync with other dbs they rely on? So if I back up DB1 from a server, and it uses another db ...
2
votes
1answer
1k views

Sql Server differential backup : Simple vs Full recovery model

I need to better understand the backup process under SQL Server 2008. Since drive space is a kind of matter for us and we want to have a better disaster recovery solution, I decided that we will ...
0
votes
1answer
3k views

What does SQL Server's BACKUPIO wait type mean?

I'm using Sql Server 2008 ("R1"), with some maintenance plans that back up my databases to a network share. Some of my backup jobs show long waits of type "BACKUPIO". Of course it seems like this is ...
2
votes
2answers
2k views

How to schedule daily backup in MSSQL Server 2008 Web Edition

In MSSQL Management Studio I created a maintenance plan but it won't work Error is; "Message Executed as user: Administrator. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for ...
3
votes
2answers
464 views

Move a Database that is in restore mode

I have a database which is the recipient of a logshipping process. The database is in 'restoring'. Is it possible to move this database? EDIT Just to clarify what I meant by move. I mean to make a ...
0
votes
2answers
3k views

How to replicate windows server 2008?

We have 2 servers let's call them server A and server B. Server B is never used unless something goes wrong with server A. I need a system that can replicate server A to server B but this doesn't have ...
2
votes
1answer
2k views

How to monitor SQL Server backups with Nagios?

How can I set up Nagios to monitor the health of SQL Server (SQL Agent) backups?
1
vote
1answer
2k views

Windows Backup failed as another backup or recovery is in progress

i have set up backup schedule on our server. SQL Server 2008 to 01:00am on windows server 2008 R2 to 4:00am. Sql backup runs well, but system backup ends sometimes with error. The error is : ...
1
vote
1answer
998 views

Sql Server 2008 Backups not quite running

I'm running a server with SQL 2008, and backing up the database with a "regular maintenance plan". (I'm not an expert by far in configuring SQL Server). The execution of this plan is automated by a ...
0
votes
1answer
1k views

SQL Server 2008 Recovery Mode reverts from FULL to SIMPLE

Three of our SQL databases have their recovery model change every night from FULL to SIMPLE. The only jobs that I'm aware of are two BackupExec jobs that run nightly. Why would the recovery model ...