Viewing 15 posts - 106 through 120 (of 210 total)
Right. In SQL 2005 you are able to take a log backup while a full backup is going on. This will revolutionize backup strategies ;}
I also agree with the idea...
June 24, 2005 at 4:51 am
I agree with an earlier post that backup/restore is the easiest way to peform this database copy. The great part about backup/restore is you don't have to take the source...
June 23, 2005 at 7:39 am
if you are having overlapping restores than typically the error was related to one of two things.
1) An I/O error resulting from a huge number of concurrent writes to your...
June 23, 2005 at 7:33 am
I'm not sure if snapshot backups can be done by veritas or not. There are a few companies that do snapshot backups but is typically an expensive solution. Snapshot backups...
June 23, 2005 at 7:31 am
A shutdown on the production (source) system should not affect the status of the destination (target) server. The only thing that should cause the target server to come up...
June 21, 2005 at 12:29 pm
Replication or triggers will give you what your looking for but at a substantial overhead price. The only solutions I can think of are either expensive (in price), for...
June 21, 2005 at 12:22 pm
If you want a live copy of the database on the development server you will need enough space on the server to restore the database. There is no other option....
June 21, 2005 at 12:16 pm
If you have a very dynamic table QA or EM may be grabbing the table info from cache.
June 20, 2005 at 3:32 pm
As you've seen this error message is useless. In order to get a better error message try editting the job step and including an output file in the advanced tab. ...
June 20, 2005 at 3:30 pm
1) You cannot recover this data. If a crash happens in the middle of a full backup you cannot recover the data that was updated/inserted/deleted since the last tlog backup. ...
June 20, 2005 at 3:27 pm
Can you elaborate on the LiteSpeed part of that response. Is sounds like you are saying that LiteSpeed does not allow for transaction log backups which it certaintly does. LiteSpeed...
June 14, 2005 at 3:05 pm
Better call up Legato support. This is not a native sql server error.
June 14, 2005 at 11:27 am
Do you have AWE enabled on this machine. There are several issues with SP4 and AWE. Microsoft has announced that no one running a server with AWE enabled...
June 3, 2005 at 4:06 pm
Coefficient certaintly is an execellent tool for analyzing performance on a SQL Code and Stored procedure level. It will detect things like deadlocks and poorly designed SQL queries.
For a real...
May 27, 2005 at 1:10 pm
You can also look in Enterprise Manager -> management folder -> current activity -> process info.
From this screen you can see all connections and kill users.
May 26, 2005 at 6:18 am
Viewing 15 posts - 106 through 120 (of 210 total)