Viewing 15 posts - 676 through 690 (of 691 total)
If you change your sa password, I'd make sure that it is a very secure password. Make it long and include both numbers and special chars (!@#$%&*...)
Steve Phelps
SQL Server...
October 28, 2003 at 7:38 am
Please run DBCC SHOWCONTIG (dbname) on each database and post the results.
Steve Phelps
SQL Server DBA
American Fidelity Group
October 28, 2003 at 7:28 am
Look at sp_rename. Based on your original question, I assume that your procs are not in master. So, you might write a script that finds everything in sysobjects...
October 28, 2003 at 7:00 am
If the original database has been around a while, and has had lots of inserts/deletes/updates, and you've never de-fragmented it, it could have been highly fragmented, which would cause it...
October 27, 2003 at 3:50 pm
The database can have users/processes while performing a backup.
Steve Phelps
SQL Server DBA
American Fidelity Group
October 27, 2003 at 3:38 pm
Jennifer,
A full backup will not affect log size or log usage. DBCC SHRINKFILE won't work either unless you have unused space in your log. You need to truncate...
October 27, 2003 at 3:26 pm
Do you have a backup of the msdb database prior to removing builtin/admin? If so, you can restore msdb and your builtin/admin will be back.
Failing that, to...
October 9, 2003 at 7:24 am
You can build the command before going to xp_cmdshell....
SET @cmd = 'NET SEND ' + @Recipient + ' ' + @Message
EXEC master.dbo.xp_cmdshell @cmd, NO_OUTPUT
Steve Phelps
SQL Server DBA
American Fidelity Group
October 1, 2003 at 3:41 pm
Just a thought...
You are initializing the devices, and creating the database before trying to restore, right???
Steve Phelps
SQL Server DBA
American Fidelity Group
October 1, 2003 at 3:37 pm
I'd like to thank everyone for their input on this. It seems "solution #1" wins hands down. The only problem that I have with "solution #1" is scheduling...
January 10, 2003 at 10:44 am
Chandu,
If your database is 600mb and your transaction log has grown to 16gb, and you are taking nightly backups, I assume that you are only taking full database backups. In...
January 6, 2003 at 9:32 am
I use a different prefix simply to differentiate my sp's from the microsoft supplied sp's. If they all start with my special "af" prefix, they're easy to identify as...
November 11, 2002 at 11:47 am
If the recovery model is set to simple, the backup statement that you ran would have failed...
--backup log eXpress to sql1backup
Server: Msg 4208, Level 16, State 1, Line 1
The statement...
October 24, 2002 at 11:17 am
Thank you for the responses. The situation has been resolved. It was discovered that one of our network administrators had been "messing" with the accounts that all of...
October 23, 2002 at 9:29 am
Ricky,
You have another beer waiting for you in Oklahoma City, OK!
Thanks!
August 9, 2002 at 1:45 pm
Viewing 15 posts - 676 through 690 (of 691 total)