Recent content by MDCrab

Hi, someone has intercepted the password to my Exchange Server mailbox. this same person has access to the Brightstor backups for our company. i fear that my privacy is going to be compromised. Does anyone here have any ideas how I can stop this from happening? the potential loss i face...

Lonnie, Re: VPN, I don't see what the difference is. The source database has to be opened up on the firewall. This invites hacking, malicious requests.

it's possible, but dangerous. The network engineer of the company that has the source server has to open up their firewall to enable this. That enables nasty people/nasty bots to try to hack into the source server.

SQL has a concept of "user mappings" that might be important to you. Basically, each database has a list of users that can access it. You may need to add this woman as a user to the database in question. Also, if you want to change the default database that a particular login sees, change the...

Hi, I'm happy to report that I've made a breakthrough and my problem appears to be resolved. Here are the steps I took: 1. I unattached the database in question and renamed the log file. Then I reattached the database. This created a new log file. 2. with the new log file I am able to...

Hi Jay, It is a user DB. It isn't used by a 3rd party app or tool. I created the structure. I populate it with a series of insert statements. The insert statements are called by an ASP script which connects to the database. thanks.

Hi Jay, Sorry for the delay in responding. I was off for nearly a week. The database size is 2.6 GB. The log file (i.e., LDF file) is only 20 MB. The total storage space free is 268 GB. So, we've got plenty of room for this database. I went to the database and right-clicked on the name...

Hi Jay, I'll respond to your questions when i return to the office in a few days. thanks.

hello, I've got an insert statement that keeps failing when I call it from a SQL 2005 stored procedure. (This insert statement attempts to put 22,000 records in a table.) After I try to call the stored procedure, I check the SQL logs for information. It tells me: "Autogrow of file...

Hi Denny, I appreciate the reply. I've been slammed recently so I haven't had a chance yet to try your remedy. thanks.

Hi Denny, I'm afraid to use the the 'alter database modify file' command on our production database. The database has the correct name in SQL Enterprise Manager. The MDF and LDF files are also appropriately named. It just doesn't have the right Physical_Name when backups are made. If that's...

Denny, Yes, the Physical_Name that shows up when I query the sys.database_files is the incorrect file name that keeps on showing up when I do "restore filelistonly" on the backups. thanks.

Hi Denny, I just made a backup of one of our key databases. Then I did a restore filelistonly on the backup I created. This backup also has the wrong PhysicalName. I expect that the PhysicalName will be the name of the database file. So, if I had a database named: c:\program...

Hi Denny, thanks for the suggestion. I did a filelistonly on the backup device and the PhysicalName is again, wrong. However, when I view the "database" name for the device it shows the correct database. I deleted the backup device and created it again. Then I ran the job that writes to it...

Hello, I'm the SQL DBA and one of my responsibilities is verifying the SQL backup devices (that I have configured). We're running SQL 2005. One method I've been using is to run a query similiar to this in the Management Studio's query analyzer: restore filelistonly from...