1
vote
0answers
74 views

1 TB Database import, best options? [on hold]

Friends, We have received 1 TB external hard drive with 750 GB MS SQL server zipped backup file in it from our client. We need to import this database at our end and then write programs to retrieve ...
3
votes
1answer
53 views

Differential/T-Log LSN question

So, this is now my third question on this topic. I just keep finding more and more than i want to know and understand about how FULL recovery works. We transitioned a database to FULL yesterday by ...
1
vote
1answer
60 views

Restore Verify Only w/ Transaction Log Backups

Question When RESTORE VERIFY ONLY on a transaction log backup fails, what do you do? Background After FULL and DIFFERENTIAL backups, I run RESTORE VERIFY ONLY on the backup file(s). This rarely ever ...
2
votes
3answers
48 views

how to restore differential back daily basis on sql server DB

Im working with SQL Server DB, what i need is that i have a DB1 and clients site communicate with this DB,Reporting module of the application is also using the same DB (i-e That shows different ...
4
votes
1answer
90 views

FULL recovery and differential backups

I am going to begin transitioning several of our databases to FULL recovery from SIMPLE. I asked a question last week regarding deployment strategies and I have one additional question. Consider ...
21
votes
8answers
2k views

Security implications of restoring a backup from an unknown source?

Scenario: You're handed a database backup and told to restore it to a server (that's already hosting other databases), but are given no useful information about what the backup contains or whether the ...
1
vote
1answer
47 views

MS SQL Server 2012: once a day full replication (automatic backup/restore) for reporting

Our company is w/o a DBA, and it has fallen on me (a complete DB noob) to handle some critical database tasks. I'm looking for the best solution for us to be able to "copy" a full database to another ...
1
vote
1answer
72 views

SQL Server DIFFERENTIAL BACKUP question?

Simple question At what point is a differential backup considered transactionally consistent? Is it the creation date of the DIFF, or the time at which it completes? That is if I restore it what ...
0
votes
2answers
78 views

What is the use of “Backup set will Expire:” option while creating Backup Database task in Maintenance plan

While backing up the database, I would like to use "Backup set will Expire:" option to delete/overwrite old database backups. I am not able to use this option. Any advice on how to use "Backup set ...
1
vote
1answer
77 views

SQL Server 2005 Restore Backup Status Recovery Pending

So at work something dreadful happened a database server went down and I am having an issue recovering one of our databases from our backups. When I try to restore from a backup using SQL Management ...
1
vote
2answers
95 views

Backup of database X on SQL Server 2008 on server A - restore to SQL Server 2012 database Y on server B

I want to copy a SQL Server 2008 database to SQL Server 2012 with a different database name. Took a backup of 'production' and copied it to the SQL Server 2012 machine. Created a new SQL Server 2012 ...
2
votes
2answers
74 views

how to create backup for stored procedure,trigger and functions of a database in sql server 2008?

I'm having 2 databases in 2 different servers(.246 and .252). I need to create backup for all stored procedures, triggers and function from 252 server and restore it in 246 server.database name in ...
4
votes
1answer
74 views

Which version of Microsoft Tape Format is supported by which MS SQL Server

When you create a backup with Microsoft Sql Server, the resulting file is in Microsoft Tape Format. Different versions of SQL Server apparently use different version of this format. Which version of ...
0
votes
1answer
95 views

MS SQL Server 2008 R2 network backup

Can MS SQL 2008 R2 backup database to a file on different network location...I've been unable to set network path for backup to other machine on local network via tasks-backup-destination.add ...
1
vote
0answers
98 views

Backup failed due to lack of hard drive space…how?

I had a maintenance plan fail last night (runs daily) for the first time in ages. The following is the specific error I received, minus the actual database name: Extend Disk Backup: failure on ...
-2
votes
2answers
87 views

How to Find All SQL Server database back list in my system? [closed]

My SQL Server 2008 R2 system has different database backups on different drives like C:, D:, E: Now I would like to see all database backups listed in SQL Server 2008 R2. Thanks for your time
1
vote
2answers
43 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.
0
votes
1answer
79 views

SQL Server FILELISTONLY command providing incorrect logical database name

When using RESTORE FILELISTONLY to restore a database using code the logical_name for the files is coming back as 423. However when I do a manual restore of the database the logical file name appears ...
1
vote
0answers
200 views

Backup Restore Procedure error SQL Server 2008 R2

We use a stored procedure to do a backup and restore of databases as a copy function. This allows our front end users to spin up sites from pre created template databases. Lately we've been getting ...
0
votes
0answers
329 views

Restore a backup from SQL Server 2008 R2 to SQL Server 2014 [closed]

How can I restore a backup from an earlier SQL Server 2008 R2 version to SQL Server 2014? The error I get is 38: reached the end of file although the file is not corrupted. Thank you.
5
votes
3answers
328 views

Restricting users to COPY ONLY backups

I am looking to deploy log shipping in my production environment. This will mean I will have to manage backup chains which could be disrupted by people taking backups to refresh development ...
2
votes
0answers
97 views

Sql Server 2012 Enterprise Backup with no file [closed]

We currently have a database which increments 5TB a day. The current backup solution we have uses Avamar, which I believe does a kind of block comparison backup where there is no need for an actual ...
7
votes
1answer
243 views

Restoring differential backup creates DEFUNCT log file?

Here is my problem. I'm trying to move a database to a new server via a full restore, then cutover with a quick differential backup/restore. I can do a full restore without a problem, but when ...
0
votes
1answer
53 views

Slow performance of remote restore

Over the weekend, I was participating in a DR test. On the database side, that meant restoring backups from the production system to the DR system. What struck me as odd about the performance of the ...
5
votes
4answers
205 views

Only do log backup if necessary in SQL Server

We have transaction log backups taken every few minutes from many databases. Is there a way to determine if there were any committed transactions since the last backup and only then do a log backup? ...
2
votes
1answer
212 views

Database Backup from 2008 R2, Restore on 2012 Failover Cluster Instance

I have a production database server having sql server 2008r2. This is an old server and considering our load, we are moving to a better hardware configuration, Now the new environment is a cluster ...
4
votes
1answer
76 views

Understanding Backup Types

I have recently started a role as a junior DBA... Yesterday I created a new database for a co-worker and my boss asked me to make sure we get a backup plan on it asap. I didn't think much about it, ...
-2
votes
4answers
577 views

how to restore .bkp file in SQL Server [closed]

I have a .bkp file, how can I restore it to SQL Server? I have SQL Server 2008 and SQL Server 2012. Any idea?
1
vote
3answers
90 views

Is bulk-logged recovery model ever a good choice if point-in-time restore is not needed?

Is the Bulk-Logged recovery model in SQL Server ever preferable to Simple if point-in-time restore is never needed? I have read many articles about transaction log models, but cannot find a clear ...
3
votes
1answer
57 views

How dependent are backups on msdb tables like backupset?

I am trying to get some practice making a backup maintenance plan and restoring those backups. I have a script that churns through the most recent full database backup and any subsequent transaction ...
1
vote
2answers
72 views

Backing up my SQL Server System Databases

I'm trying to create a recurring scheduled job to fully backup the master, msdb and model databases, I'm using the Maintenance Plans for SQL Server 2008 R2, in the "Specific Databases to choose from ...
1
vote
1answer
46 views

Backups in Availability Groups

In case of async commit setup and the backup preference set to secondary replica. I have observed, in case of high unsent log size, log backup on secondary replica starts failing for that database ...
1
vote
0answers
115 views

What's is the best way to get incremental changes from production to incrementally changed development database?

I came to a new dev team where all development is on the same (instance) of an SQL Server (2005) database once in 1-2 days restored from a current full backup of production database replacing a dev ...
1
vote
1answer
2k views

Query that displays backup information (successful and failed) SQL Server

I have two jobs that backs up two different databases. Job 1 backs up DB1 Job 2 backs up DB2 DB1 fails to back up due to low space on Drive 1 resulting to a Job 1 failure. To fix that issue, I just ...
0
votes
0answers
42 views

Backup is getting failed with following error

Msg 3202, Level 16, State 1, Line 1 Write on "\w-mum-fp\SQLBKP\Weekly-FL\Interactions_26_01_2014.bak" failed: 1130 (Not enough server storage is available to process this command.) Msg 3013, ...
1
vote
0answers
74 views

Differential backup job is working but not the Full daily backup

I have a full backup job for my database that runs once daily, I see it posted daily in the folder that it should go to, but when I check the "View History" for this job in SQL Server Agent, there are ...
3
votes
1answer
1k views

“Database is in transition” Error

Today I was trying to restore a database over an already existing database, I simply right clicked the database in SSMS --> Tasks --> Take Offline so I could restore the database. A small pop up ...
0
votes
0answers
181 views

SQL Server backup/restore between systems with different storage sector sizes

We have a system where we create template databases and back them up and distribute them to customers. We recently upgraded our 'build' server to use SSD with a 512 sector size and received an error ...
1
vote
2answers
169 views

T-SQL script to perform a compressed backup with maximum compression level [duplicate]

I have a database with full backup of almost 2GB. When I perform a full backup (without compression) and then compress it with winrar it become 140MB, but when I backup WITH COMPRESSION syntax the ...
2
votes
2answers
59 views

What is the purpose of BACKUP WITH NAME?

I looked at the Microsoft documentation (http://technet.microsoft.com/en-us/library/ms186865.aspx) and see that there is a WITH NAME option for backups. But it's not the name of the file (I specify ...
2
votes
2answers
556 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 ...
0
votes
2answers
76 views

Copying a restoring database in SQL Server 2012

I've got two SQL Servers, one of these servers (Server A) is backing up transaction logs on some database and uploading them to the other (Server B). Unfortunately I have no access to Server A, I ...
0
votes
0answers
169 views

Database backuped, but “Last database backup” property shows bad date

I have this procedure below to backup database(procedure is in backuped database). Procedure is called by external program. Procedure runs fine, backups are created. But when I want to find out last ...
0
votes
2answers
75 views

Backup and truncate LDF with xp_sqlmaint

A job is backing up an LDF with the following command: EXECUTE master.dbo.xp_sqlmaint N'-PlanID <the id> -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog "\\server\sqlbak$" -DelBkUps 6HOURS ...
1
vote
1answer
47 views

How to document an archived database? [closed]

You've stored the backup file in a safe place, but what kind of info do you store with it? database type (SQL Server) compatibility level (SQL Server 2008) application name application owner ...
1
vote
0answers
44 views

Multiple backups during the night but only one instance of the maintenance plan [closed]

FIRST THING FIRST: I'm a C# developer, I'm the only person here that know how to manage an SQL server, but I met my limits on this one. Thank you in advance for your help. I'm not sure if my title is ...
1
vote
2answers
172 views

What are the primary architectural differences between the backup formats of some of the more common RDBMS' and what advantage do they serve?

Of the systems with which I am familiar, I have noticed that SQL Server's native database backup format is binary and proprietary. PostgreSQL and MySQL allow for a simpler approach, dumping the ...
3
votes
2answers
103 views

if database is not shrinked does it affect backup size?

Ok my question is simple. Lets say that when i click database and hover over shrink it says it can be reduced 1 GB space. Now when i do a backup of this database, does this space also getting added ...
4
votes
3answers
502 views

Is SQL Server's FILETABLE suitable for storing large files (bigger than 10 GB)?

There is a project for lab. The requirement to save the lab data (raw data and related infomation ) for research for years. So the data must be saved for years, but the data is so big, every raw ...
3
votes
2answers
104 views

Restore database to a instance in network

We are creating a application which requires sql database as backend to store data. So when user install my application he chooses a sql instance and its details. There we plan to restore the database ...