Tagged Questions
0
votes
1answer
27 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
136 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
68 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
536 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
129 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
1answer
222 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
160 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
62 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
249 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).
...
2
votes
3answers
445 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
468 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
344 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
67 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
448 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
153 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
83 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
76 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 ...
0
votes
3answers
125 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
4k 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
323 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
368 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
247 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
239 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
219 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
130 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
163 views
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
92 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
101 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
114 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
152 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
264 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
3k 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
220 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
447 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
2answers
461 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
3k 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
2k 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
414 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
2k 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
1k 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
862 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
990 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 ...
0
votes
2answers
66 views
SQL Server backup issue
I am using SQL Server 2008 Enterprise on Windows Server 2008 x64. I want to run daily job at mid-night every day to make full backup of database. Any reference document to follow for a newbie of this ...
1
vote
5answers
4k views
Automate SQL Server 2008 backup script failing to run
I have created a maintenance plan but when I try to execute I get the error:
Message
[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'XX\Administrator', error ...
