Error on Transaction log Backups
Getting error -1073548784, when trying to run a backup of transactions logs ( SQL SERVER 2008, STD ed). Can anyone help?  

Answer Question   |  May 30, 2012  9:15 PM
SQL Server backup

detach the .mdf files from sql server
hello, i am trying to detach the database from sql server. well the seniorio is i am try to do automate everymonth to detach all the previous month .mdf files. so is it possible to automate it to detach the previous months database by getting the system current date.

Answer Question   |  March 6, 2012  10:03 PM
SQL Server, SQL Server backup

SQL Server backup to remote internet location
We have one server with 2 SQL databases with size 1.5GB and 6GB, Daily new transactions are added to the system. Now we want a solution that this SQL gets backed up / replicated at some remote internet location on daily basis. Since we cannot transpot full 1.5GB file or 6GB file on daily basis, [...]

Answer Question   |  October 20, 2011  10:21 AM
SQL Backup, SQL Database, SQL Server, SQL Server backup

SQL Server 2008 restore error
error message : The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)

Answer Question   |  March 12, 2012  7:33 AM
Restore Database, SQL Server 2008, SQL Server 2008 error messages, SQL Server backup, SQL Server backup and restore

I want to create backup of SQL database and set a password.
HEllo All  i want to create backup of SQL database and want to set Password that anyone who restore this backup after that it cant be able to restore database without knowing perticular Password …. is this Possible….? if Yes please tell me How…? Thanking You Raviraj

Answer Question   |  April 9, 2011  7:15 AM
SQL Backup, SQL Data Types, SQL Server backup, SQL Server database, SQL Server security

Recovering lost data from SQL Server 2005
Running SQL Server 2005. I found that I had lost about 2000 records the Assets table and more records in the associated tables Timeassets and AssetBillingrates.  Each of the tables uses an Id field as the Primary Key. I was able to identify the key records that had been lost and tried inserting them From [...]

Answer Question   |  April 2, 2011  6:19 PM
INSERT statement, SQL Server 2005, SQL Server 2005 backup, SQL Server backup

DB backup onto External Hardrive
Hi I have connected an external USB hard drive to my SQL server (2000). When i attempt to backup from Enterprise manager (to the harddrive) i cant seem to find the drive in the list. The drive has been made active (active partition) and can be used from windows explorer without any problems. I would appreciate [...]

Answer Question   |  March 12, 2011  4:52 PM
Backup, External hard drives, SQL Backup, SQL Server, SQL Server backup

Restore SQL Server after OS loss
I have all datafiles and backups but no OS services. What steps would I take to restore the database

Answer Question   |  February 21, 2011  11:05 AM
Backup, SQL Server, SQL Server backup, SQL Server backup and restore

Can I restore a SQL 2000 backup to a new SQL Server 2005?
Can I restore a SQL 2000 backup to my new SQL Server 2005? Will I have to perform any other steps or can I do a simple backup and restore? Windows 2008 Server.

Answer Question   |  September 8, 2010  8:32 PM
SQL 2000, SQL migration, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server backup, SQL Server migration, Windows Server 2008

Recovering data from crashed database
i   i have a question. my database  is crash .i don’t have present backups.but i’m having  last week backups.  and  backup  strategy sunday   10 p.m  full backup everyday  1 p.m    differential backup every one hour transaction log backup  please give me reply as soon as thanks & regards venkat

Answer Question   |  August 20, 2010  7:31 AM
Backup, Backup & recovery, Database Recovery, DBA, SQL Server, SQL Server backup

Incremental backup in SQL server 2005 and SQL Server 2005 express
Question: a) steps to backup the daily incremental in sql server 2005. b) steps to backup the daily incremental in sql server 2005 express.

Answer Question   |  August 19, 2010  6:04 AM
Backup, Incremental backup, SQL Server 2005, SQL Server 2005 backup, SQL Server 2005 Express, SQL Server backup

Mirroring SQL Server 2008 to a disaster recovery machine twice a day
I want to mirror my SQL Server 2008 to a disaster recovery machine two times a day. Is there any free software to do this on a running SQL Server? If not, are there any cheap alternatives? Can scripts be run to copy the files over while SQL is running? Can I use shadow copy [...]

Answer Question   |  July 21, 2010  1:59 PM
Disaster Recovery, Shadow Copy, SQL Server, SQL Server 2008, SQL Server backup, SQL Server database

SQL Recovery from MDF and LDF – Missing Data
Where to start … On 6/2 we lost a major system that we found relies on a database that hasn’t been backed up since 5/7. We lost 3 of 4 HDD in a RAID5 array. We sent the drives to a recovery firm and they have recovered all of the data. However, the timestamp on [...]

Answer Question   |  October 5, 2011  2:10 PM
LDF, MDF, SQL 2000, SQL Server 2000, SQL Server backup, SQL Server backup and restore

SQL Server Log Shipping 2005 to 2008
Does anyone know if i can logship from a sql server 2005 to a sql server 2008?

Answer Question   |  May 10, 2010  7:07 PM
Backup and recovery software, SQL Server 2005, SQL Server 2005 log shipping, SQL Server 2008, SQL Server backup

BACKUP in SQL SERVER
Hello Sir, Can u get me the answer  to this question Management wants the backups to be done daily. Transaction log backups must be every afternoon and morning and that you should keep in mind that the content of the log will get larger and larger. You also need to take measure to do the log file. [...]

Answer Question   |  May 7, 2010  6:21 AM
SQL Server backup, SQL Server logs

Retrieving data tables without backup SQL
If I truncate a table without the backup of it, how do I retrieve the table data?

Answer Question   |  April 9, 2010  3:23 PM
SQL Data Types, SQL Server backup, SQL Server tables, SQL tables

FULL BACKUP taken by SQLExecDirect function works, but backup is not taken why?
I try to backup SQL server database using ODBC native client apis. One weird error occurs. When I run, SQLExecDirect(stmt, “BACKUP DATABASE dbname TO DISK=’C:TESTBK.BAK’ WITH FORMAT “, sql_nts ) There are no errors during runtime, and message shows backup taken . But it is not seen innthe specified folder. With the same function if [...]

Answer Question   |  November 17, 2009  2:49 PM
SQL Server backup, SQL Server error messages, SQLExecDirect

How to export/ import userschema in SQL server 2005?
To export userschema in oracle, we can use expdp and impdp commands. Do we have any commands to export/ import userschema in SQL server 2005? Also, How to export all the tables to filesystem? Using SQL management server studio there is an option to export 1 table at a time to a file.     [...]

Answer Question   |  November 4, 2009  7:14 AM
SQL Server 2005, SQL Server backup, SQL Server snapshot backup

Techniques for storing SQL Server data online and for backing up the server
For a banking application, I would like to keep 10 years worth of data using SQL Server. I would like to keep two years online and backup the other eight years. What are some techniques to do this?  

Answer Question   |  October 27, 2009  3:50 PM
Backup, Online Backup, SQL Server backup, SQL Server backup and restore

SQL Database User
Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql login (user1). Can I create the sql login on server3 and copy the [...]

Answer Question   |  September 15, 2009  9:22 PM
SQL, SQL Server, SQL Server 2005, SQL Server backup, SQL Server security