Viewing 15 posts - 91 through 105 (of 210 total)
The nice thing about backup and restore is that you can backup the database while the primary database is active, Copy the backup file while the primary is active,...
August 2, 2005 at 9:13 pm
If this is a big issue for you and you do not want to rely on triggers you can take a look at a tool that interrogates the active and...
August 2, 2005 at 10:30 am
look for a loss of network connection in the windows event log. This should isloate any issues related to lost network drives?
Has this backup been successful in the...
July 27, 2005 at 11:40 am
Check for an antivirus software or archiving software that may be grabbing hold of the file. I've had this problem before and pinpointed the problem to AV software.
July 19, 2005 at 11:25 am
As shown, there really is no way to ensure that backups can be restored unless you actually restore them. The restore verifyonly function is nice and I recommend that it...
July 5, 2005 at 4:22 am
That was really the point of the question. Say you have a 5 hour long full backup and 4 hours in, the disk containing your log file goes down. Have...
July 1, 2005 at 9:13 am
There can be no open connections into a database when it is being restored. To ensure this you can run sp_who2 inside of Query Analyzer and note which SPID's are...
June 30, 2005 at 10:01 pm
Does anyone know if SQL Server 2005 Management Studio addresses this annoyance.
June 30, 2005 at 4:42 am
The command that I use is:
BACKUP LOG <dbname> WITH TRUNCATE_ONLY
Keep in mind that this will simply remove the entries from the transaction log, it will not shrink the transaction log...
June 30, 2005 at 4:40 am
Typically using 3rd party tools to encrypt the data on the fly in the database can imply serious performance overhead. I would think that encrypting at the application level would...
June 28, 2005 at 3:07 pm
I would always recommend running SQL Server on its own dedicated box for obvious performance reasons. If you must consolodate these applications though you should at least upgrade your memory...
June 28, 2005 at 3:05 pm
Unless you have archived this file off to tape I do not know of anyway to get the file back.
June 28, 2005 at 8:33 am
You should also take a look at this article. I think it might give you what your looking for as far as determining which tables are taking up the...
June 26, 2005 at 9:14 pm
One thing that is stored in MSDB is a history of backups and restores. Are you doing a large number of backup and restores and not archiving out the...
June 26, 2005 at 9:09 pm
Another solution is to code your web application so that users cannot generate these huge queries. How about checking the parameters that the user has chosen to search on and...
June 24, 2005 at 5:05 am
Viewing 15 posts - 91 through 105 (of 210 total)