All Questions

Tagged with
Filter by
Sorted by
Tagged with
7
votes
2answers
2k views

Why is my log file so massive? 22gb. I am running log backups

I can't seem to figure out the answer. I've seen multiple answers like this: Why Does the Transaction Log Keep Growing or Run Out of Space? and everyone talks about running back ups on your log file ...
0
votes
1answer
229 views

Why does msdb.dbo.backupset have entries for each database every 15 minutes?

I have 134 separate databases on a SQL Server. Every 15 minutes an entry appears in the msdb.dbo.backupset table for each database on the server. Why does this happen every 15 minutes? What is ...
3
votes
3answers
113 views

Backing up a SQL 2008 DB, then restoring, gives a SQL 2005 (compatibility level 90) DB

We have four different databases on a SQL Server 2008 (not SP2 - don't ask me why) database server that have an odd problem. When listed from sys.databases, these databases report that their ...
0
votes
1answer
63 views

Help me with sql backups please

I'am facing some difficulties regarding my Sql Backup method, i am not sure if my method is correct, i am using a backup method described below; Created a Full backup named Xbackup in Maintenance ...
0
votes
1answer
114 views

Index Reorganize During Database Full Backup

Index maintenance usually starts 3 hours before the database full backup and ends before the full backup start. The database is using the Simple Recovery model. Last weekend the index maintenance ...
0
votes
1answer
171 views

Restoring MSSQL back-ups to Oracle 12c

I currently have an Oracle 12c DW that has several data sources of varying types (MSSQL, Oracle, MS Access, PostgreSQL, etc.) being moved into it as part of our existing ETL process. We have FME (...
9
votes
1answer
2k views

Daylight Saving time

In my environment, there are servers running on native backup and Ola Hallengren plans. Our servers are a combination of 2008, 2012 and 2014. All the full backups are taken at 12am and log backups are ...
1
vote
3answers
71 views

Full backup on failure

I have created a maintenance plan to take a full backup of all my databases every Sundays and a differential backup every day. Also, a log backup is triggered every hour. However, there is an issue ...
1
vote
1answer
49 views

Any potential complications from ms sql backup db to disk = 'nul', disk = 'nul', …?

Our development team has a tool that notifies us of issues with our DB backups, but they have not yet given us the ability to exclude certain databases from the alerts - DBs that we do not want ...
3
votes
1answer
63 views

Xp_delete deletes old backup even when the backup job failed

I run the following scripts for a backup job. After the backup job completes, (xp_delete) deletes the old copy of full backup. Typically, if the backup fails the BACKUP DATABASE statement on the 2nd ...
0
votes
1answer
32 views

Only backup drive and differential backups

Is it possible to restore the differential backup without a full backup, but having backup of the entire hard disk? Example: 2017-01-01: DIFF backup 2017-01-02: entire hard disk backup (NO FULL ...
0
votes
1answer
118 views

Full and differential backups are taking way longer only from one server

I see a perplexing issue on one quasi-production machine (SQL Server 2008 SP2 standard edition) only. Full and differential backup job all of a sudden started taking 48 hours since 2/4/2017. Full ...
2
votes
1answer
57 views

Do I need to worry about RESTORE FILELISTONLY types other than L and D?

According to https://msdn.microsoft.com/en-us/library/ms173778.aspx, there are four types, L, D, F and S. All of the actual database instances I've seen so far (SQL Server 2008 and up) only have ...
1
vote
1answer
93 views

Database Backup compression

I am trying to see all of my backups are compressed or not. I ran below query to check but not getting good result: select top(10) database_name, case when backup_size = compressed_backup_size then ...
0
votes
1answer
969 views

Restoring corrupted bak file

Our server & Backup data got crashed and we had a recovered the data using the recovery Tool. Currently I am having .BAK Files. When we are trying to rebuild the DB using the recovered .bak file ...
1
vote
3answers
1k views

SQL Server Backup To a NAS Box

I'm trying to backup to a NAS box but I'm getting the following error: Cannot open backup device '\\nas02\backup\SQL\instance\Full-Backups\OtherDBs\Daily\MGMT_TEST.bak'. Operating system error 1326(...
1
vote
1answer
185 views

Restore partial data from single file of SQL Server Full Strip Backup

I don't know if I ask for something possible, but here is my problem: We had a disaster (virus) in our SQL Server Database and we lost all the information and backups. The only backup remaining is a ...
0
votes
1answer
191 views

How can I implement a quick backup and restore strategy for database script testing?

I've got a copy of our 130GB production database restored on our development SQL Server 2008 R2 Standard Edition 64-bit. I'm developing some test scripts, which need to de-duplicate a lot of data ...
0
votes
1answer
2k views

Restore of database failed .bak file SQL Server 2008

I have faced following error during restoring database: TITLE: Microsoft SQL Server Management Studio Restore failed for Server (Microsoft.SqlServer.SmoExtended) ADDITIONAL INFORMATION: ...
3
votes
2answers
1k views

Why database snapshot creation is faster than normal database backups?

Could you tell me any reason why creation of database snapshot is faster than database normal database backups in MS SQL server
1
vote
1answer
2k views

How to backup SQL Server database once evaluation period has expired

I'm using Microsoft SQL Server Management Studio from last one month that is evaluation period software. I'm not able to login in management studio. when I enter my user name and password it gives the ...
5
votes
3answers
4k views

How can I make a database backup go faster?

I recently attended an interview for my next job and was asked this: How can I speed up the backup of a database sized close to 1TB or 800 GB in SQL Server? My Answer: We can use Database ...
-3
votes
1answer
175 views

Backup file from SQL Server 2012 to 2008 [duplicate]

I have a backup file of SQL Server version 2012 but I want to restore that backup on SQL Server 2008. Question: Is this possible ?
2
votes
1answer
482 views

Backing up / restoring a 20GB database with images stored as binary code

I am trying to backup and restore a 20GB database from a SQL Server 2012 to another SQL Server 2014, but I have come across the following issues: The developers [against best practice] have stored ...
-3
votes
1answer
1k views

Generate Script Of Database in SQL Server 2008 [closed]

How to Create Script for the Database Objects in SQL server 2008 r2 and restore it in database.
15
votes
5answers
2k views

Backing up & restoring 10-20 SQL Server databases to a ~synchronous state?

I need to backup up 10-20 SQL Server 2008 R2 databases with sizes between 10-50 GB, while they are online and used simultaneously by a single enterprise app. I also need to restore them to a state ...
-2
votes
1answer
128 views

Restored database smaller than the backup file [closed]

The new database created from a restore file is half the size of the backup file I restored from. Why? Original backup settings: Recovery Model: SIMPLE Backup Type: FULL
11
votes
2answers
5k views

Can't find process that is creating backups

We have an instance of SQL Server 2008 installed on a customer server. The customer's IT department is in charge of the various backups of the machine. The SQL Server log shows there is a full backup ...
5
votes
1answer
654 views

SQL Server restore differential after restoring full backup

Here is the situation: I had a full backup, and a differential backup. I have restored the full backup into the database. But accidentally lost that backup file. Now I would like to apply the ...
2
votes
3answers
9k views

Restore SQL Server 2008 database onto SQL Server 2014?

I have a backup file that I need to restore daily on schedule based. But the backup file is from SQL Server 2008 and restore destination is SQL Server 2014. And also the backup file is from cross ...
2
votes
1answer
244 views

How to do housekeep the database in sql server 2008 by specific date range?

I have database with around 160 GB size. The database contains the data is from 2013 to until today, there are 180 tables, I want to remove the records in specific date range like 2013 to 2014 in all ...
3
votes
4answers
294 views

SQL Server 2008 backup script

I have a lot of SharePoint 2013 databases to backup and if update fail to restore, so I want to automate this operations. ALTER DATABASE [TEST_1] SET OFFLINE WITH ROLLBACK IMMEDIATE GO BACKUP ...
4
votes
1answer
313 views

Preventing full backups for unmodified/slightly modified databases

Is there a way to either: ensure that unmodified databases are skipped during SQL backups, or even better choose between DIFF or FULL backup depending on the percent database changed since last full ...
0
votes
1answer
506 views

Saving SQL Server DMV's for later use [closed]

Is it possible to save DMV's in SQL server database backup, which can be restored on different server, I mean with master db details( views and all)? If not, what's the best way to maintain 2 ...
5
votes
1answer
491 views

Is there a way to list the “last backup” file of a Database?

I'm trying to do something really simple, but with one problem: declare @cmd varchar(1000) set @cmd='restore verifyonly from disk =''\\server\backup_folder\''?''' exec sp_msforeachdb @cmd ...
3
votes
1answer
495 views

Full to Simple recovery mode during massive data update?

I`ve got a 50 Gb database, in which a table takes up 43 GB, and it's full of bad data(over 90%), and i plan to clean it. Database is in Full recovery mode. My plan is: 0 - take a backup for safety ...
2
votes
3answers
335 views

Is it possible to have 2 backup plans for a single database?

Is it possible to have two backup plans ? allow sysadmins to have their own SQL Server 2008 set of backups for a database allow DBAs to have their own separate backup plan We have had issues with ...
5
votes
2answers
21k views

Can I stop a SQL database backup after it has already started?

I am looking to do a full database backup of a SQL database in SQL Server 2008. My questions are: Can I stop, pause, or cancel the backup after it has started if it is taking too long or slowing ...
1
vote
1answer
1k views

Backup error: Failed to flush the commit table to disk

When I try to backup a SQL Server 2008 database, I receive an error: Backup failed for Server 'SQL2008TEST'. (Microsoft.SqlServer.SmoExtended) Failed to flush the commit table to disk in dbid 32 due ...
3
votes
1answer
15k views

How do I backup/restore database encryption key in order to restore on new server

I am currently in the process of restoring a TDE encrypted database to another instance. I have backed up master key and certificate, and have restored them to the new server fine, but I am still ...
1
vote
2answers
502 views

SQL Server Backup and Query Execution

Is SQL Server Backup affects the query execution performance? Is there an effect while running the SQL Server backup in remote query execution? Thanks.
5
votes
2answers
2k views

Deploy SQL Server Backup Maintenance Plan in multi-tenant environment

We have a multi-tenant environment in which I've been trying to deploy a standardised maintenance plan across all servers. I've been running into issues importing the maintenance plan properly, as ...
1
vote
1answer
825 views

can I Run a Stored Procedure across all SQL servers and return 1 html report

I have the following set up as a sp and it runs daily. It gives me a report for each SQL cluster in my environment but what I'd like to do is configure it to run across all clusters and return 1 ...
3
votes
1answer
433 views

Error with restoring from a split .bak file with password

I am trying to restore a backup from a split .bak file[.bak_1/.bak_2/.bak_3]. The backup is password protected. So far this is what I have and I cannot seem to format in a way that does not throw me ...
7
votes
3answers
33k views

SQL Server 2008 Database Restore Error - Cannot open backup device 15105

I am trying to restore from a backup and getting the following error Msg 3201, Level 16, State 2, Line 1 Cannot open backup device 'Z:\FULL_BACKUP.bak'. Operating system error 3(failed to ...
2
votes
3answers
23k views

Restoring .bak file SQL Server 2005 in SQL Server 2008

I don't have enough knowledge in SQL Server back and restore. I just want to know is it possible to restore an SQL Server 2005 .bak file in SQL Server 2008? If yes, how can I do it?
2
votes
2answers
146 views

Information on a Database that was restored with NO RECOVERY

I'm working with SQL Server 2008Sp3. I have a database that was restored from a full backup WITH NO RECOVERY and it then was restored with Transaction log backup files - also WITH NO RECOVERY. At ...
3
votes
2answers
192 views

Viewing the SQL of a view from a backup set

I have a full backup of my database from 4 days ago. It is a standard SQL 2008 .bak file. What I'd like to know is if its possible to view the SQL to a View that is in the database I backed up without ...
4
votes
3answers
7k views

Transaction log has grown huge after maintenance plan to rebuild idex

A couple of days ago I was testing some stuff using the Maintenance Plans in SQL Server 2008. I created one to rebuild indexes and take a full backup every week. (I know, bad thing I've found out ...
5
votes
3answers
1k views

Backup not creating a new file

I run a daily backup of my database through command prompt: c:\sqlcmd -H localhost -Q "BACKUP DATABASE test TO DISK='c:\test.bak'" But the new backup replaces the previous backup. Please tell me ...