View Complete Post
I have three databases named XDW, XOLTP, XOLTPSchema. All of these are for only one application. In the application, user should do backup/restore using GUI.
1. How I should do backup/restore in one transaction? i.e. all of three actions should be success elsewhere all of them should fail.
2. Is it possible to backup them into only one file e.g. X.bak?
3. Or, What is the standard solution in this condition?
Thanks in advance.
I know how to take total database backup in SQL server 2008 and SQL Server Management Studio Environment but i failed to take single table backup in database.
It is possible to take single table backup in Oracle using PL/SQL Developer IDE.
Thanks in Advance.....
i want to know what are the advantages of transaction log backup in sql server 2008?
One of my customer having problem with the transaction log backup .There is one maintenance job that will take Full backup on daily basis.and transaction log backup in 4 hrs.On Sunday there is one rebuild index job .After
this rebuild index job the transaction log is taking 17 minutes and it creates 12 gb transaction log backup (only for the first time). Usually the transaction took 6/8 seconds and the transaction file will be in less than 100 mb.
Pleas help me to resolve this issue
Thanks in advance
SQL Server 2008 Mgmt Studio doc, backup a transaction log, says clearly:
Transaction log section:
For routine log backups, keep the default selection,
Truncate the transaction log by removing inactive entries
But I have been back and forth in SQL Server 2008 Mgmt Studio, editing my Backup Database Task. I pick the
backup type Transaction Log. I see the Disk and Tape options; the backup file and subdirectory options; Verify backup integrity option; Backup the tail of the log; set backup compress
Database is in Full Recovery Model. Backup is done as follows
1) Full Back up done every Sunday 00:00
2) Differential Backup done Done Every Day at 00:00
3) Transaction Log is Backed Up Every 15minutes.
I have a problem Transaction Log Size suddenly gone to 22GB (Data File is only 100mb) and Transaction Log Backup ruinning for a long time but it is not backing up.
Why is this problem occuring? How do I solve this?
I have asp.net + sql server 2005 application running on the shared hosting. I want to regularly make sql server backup and saved in my local machine or some online storage. The problem is that the hosting environment doesn't provide sql backup service. All
their provide is a web interface myLittbleBackup for sql server, which I can manually click through and get a full backup. I want to write some program or script so I can schedule it to run daily to generate a sql backup file in my local machine(full backup
is fine since the DB is not big), how can I achieve this?
One possible way I can think of is: install sql express in my machine, write program to get full data from shared host DB to local sql express, and then do regular backup on sql express.
any idea will be appreciated!
TFS Power Tools to setup a db backup plan for a TFS 2010 instance using SQL Server 2008. The result is a sheduled full backup at 02:00 each night and a transaction log backup every 2 hours. The backups work but there is a problem with the transaction logs
not being truncated after backup. When this was brought to my attention typically all the transaction logs were 10-30 times larger than the data files... I searched the www and found these two useful commands:
SELECT name, recovery_model_desc, log_reuse_wait, log_reuse_wait_desc FROM sys.databases
For all relevant databases log_reuse_wait = 2 and log_reuse_wait_desc = LOG_BACKUP. The dbcc command told me that log files were about 95% in use.
Searched som more on thee www and ended up with this manual procedure to "fix" the problem:
We are using SQL Server 2000. There is a maintenance plan to backup three databases on a daily basis (full-backup) and their transactional log every 4 hours.
All the jobs have been running well, however, since last 3 days the transactional log backup job has been failing for one of the three databases. Transactional logs are stored on same location on disk.
I checked to confirm that there is enough space on the disk. Performed DBCC command on the database and that returned 0 errors.
I noticed the following errors:
From SQL server log:
“BACKUP failed to complete the command BACKUP LOG [XXXXXXXXXX] TO DISK = N'H:\XXXXXXXXXXXXXX.TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT”
From Database Maintenance Plan History:
“[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3241: [Microsoft][ODBC SQL Server Driver][SQL Server]The media family on device 'H:\XXXXXXXXXXXXXXXX.TRN' is incorrectly formed. SQL Server cannot process this media family. [Microsoft][ODBC SQL
Server Driver][SQL Server]BACKUP LOG is terminating abnormally”
Any help would be greatly appreciated. I've been a developer and now have to take c
Sorry I am kinda new in web services, so it may sound a bit newbish question.
We have a web service that comunicates with the database and exposes web methods that enables the application to access the database. Each method does only one operation (Insert, Update or Delete). What I need to do is create a transaction that will be consisted of multiple calls to the database, meaning multiple calls of more then one web methods. Can I do that? (I read that if the web method does not throw exception - or ContextUtil.SetAbort() is not called - the transaction will be commited automatically when the web method finishes executing, which I don't want to happen because I want to call another web method in the same transaction, and then manually commit the transaction)
Thank you in advance.
If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.
MSDN Magazine May 2009
MSDN Magazine May 2007
This article presents a general-purpose client quality reporting mechanism that can be used in any .NET-based transaction system that employs HTTP/SOAP. The design uses client response time and quality recording, upload of logs as SOAP headers attached to new transaction requests, and server handoff of these headers to a low priority queue for logging and analysis. This technique gives an enterprise near real-time information on actual end-user response times. These response times reflect network delays, client application overhead and server delays. By using this technique, enterprises can avoid the need to develop custom software to mine HTTP logs.
MSDN Magazine July 2004