0
votes
1answer
46 views

Restore From Database not showing database I want to pick

In Management Studio I want to restore to a point in time from an existing database. However, the databases that I can choose from in the drop down list don't include the one I want to choose. And ...
4
votes
2answers
3k views

Can I restore a SQL Server 2008 R2 backup to SQL Server 2008 R2 Express?

I have a server that's currently running SQL Server 2005 Express, and I need to restore a database backup that a developer has modified using SQL Server 2008 R2 [I think the full version, but still ...
1
vote
4answers
216 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
1answer
82 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
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
1answer
136 views

SQL 2008 R2 Enterprise Compatible

We currently have SQL 2008 (non R2) installed on our development server. Our production server has SQL 2008 R2 Standard, so we would like to upgrade our development server so they are "compatible". ...
2
votes
1answer
354 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 ...
1
vote
3answers
4k views

“RESTORE HEADERONLY is terminating abnormally” error when restoring backup

When I try to restore a database backup file, I get the following error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ...
0
votes
3answers
2k views

Backup single table MS SQL SERVER

how to take a back up of single table and restore it back when I required. I mean,I need back of single table with all the indexes,constraints and data associated with that table. because I want to ...
0
votes
1answer
54 views

Restoring a DataBase

i have two deferent Servers databases connections , let say j and k .. and i have backup data file in j, i named it jtok.bak .. now , i am trying to restore a database in k from jtok.bak , the ...
3
votes
2answers
374 views

SQL Server 2008 - scheduled copy of production database into test and development databases

I wish to schedule a copy from my production database into two other databases. The databases are located on same server (instance?). The databases are currently backed up to server hard drive every ...