Viewing 15 posts - 61 through 75 (of 462 total)
Andy,
I don't think that's possible. But below are couple of options.
1) You can move your data files to a different location when your server crashes. Hence the database will come...
March 18, 2005 at 9:21 am
I think it might give you a more descriptive error when it tries to delete the files than just an exit code of 1. Does the report show an attempt to...
March 18, 2005 at 9:03 am
Try re-creating the maintenance plan. I did see this behavior a while back but have not come across this in a while.
March 17, 2005 at 1:15 pm
Brian is right. I didn't see that it was production.
March 16, 2005 at 2:09 pm
You can do a nbtstat -a servername and see what domains your server is registered in.
March 16, 2005 at 1:58 pm
you can also try to clear the buffers by executing dbcc freeproccache and see if that helps.
March 16, 2005 at 1:14 pm
It seems that the setup is not seeing the shared disk resources. Can you please mention how you have the disk resources configured ?
March 15, 2005 at 7:55 am
You can use a truncate statement to make the table empty. But this will delete all your data.
If you need part of the data, you can read the data required...
March 14, 2005 at 1:27 pm
SQL Server will always start using the account which you specify under services. The SQL Server startup account does not need sa privileges to start sql services. The startup account...
March 11, 2005 at 7:54 am
You can grant sa access to NT Authority\System account if you are using local system account and want to revoke access to builtin\Administrator group.
March 10, 2005 at 8:58 pm
Alert 18278 fires when log gets truncated. You can configure this.
March 8, 2005 at 11:06 am
If you are trying to attach all the files to a simillar location as the current server, you can use the script below. It will print out the script with...
March 7, 2005 at 8:20 am
Something you might want to try is add an entry for dbo in sysusers. It should have a uid of 1.You can copy the values for all the fields from another database.
Please...
March 7, 2005 at 7:51 am
You are right brian. Need to verify whether it is NT or Active Directory.
March 3, 2005 at 10:33 am
Viewing 15 posts - 61 through 75 (of 462 total)