Hi,

What happens if you copy a large file to the backup location? Will this also bring the SAN disk down? If so, it looks like the problem is caused by...

First: define the smallest datatype possible for all of your columns. So you probably should change the ID to an INT datatype and the Lodging, FoodBill and DailyAllowance to a...

Yes, it's possible. You have to use dynamic SQL to accomplish it. Below I quickly created a small stored procedure that does the trick. I didn't include any error handling,...

I'm not sure, but it looks like the storage for the third party backup application (Tridion) is offline. Determine the storage box/path used by this resource and see what problems...

Unless you have installed SQL on a cluster, you can't assign an IP-address to the SQL instance. The SQL instance will use the IP-address of the host server / pc.

There is no need for a trigger or something else. This is the key to a relational database design.

The value (of VENDOR_NAME) is stated on one position and is displayed...

Yes, recover lost data from a backup is the reason why you take backup.

Restore the last FULL and last DIFF (if applicable) backup with the NORECOVERY option to an alternate...

Can you pin point the error to a specific database?

Can you manually perform a FULL and DIFF back-up on that database?

The most common setting is to set the growth to unrestricted. But you must keep monitoring the available disksize and the size of the database.

In our environment we had some...

Run below code to see which databases does and does not have a full backup. Check the date to see if the last full backup is recent enough.

select db.name, database_id,...

First: I am using SQL 2008 and not SQL 2000, so maybe it's not representative.

Do determine if the combination of the executable and the arguments field work correctly, I have...

jamie.lawrence (8/16/2013)

---

i see my error. i have entered the correct path of the exe but when i execute the process all that happend is that the exe opens. it seems...

Will it succeed if you enter the drive, path and executable as a single line (i.e. "C:\Program Files\HSCIC\#grouperFolderName#\HRGGrouper.exe") in the executable field and the rest in the arguments field?

Long time ago I found this script on the internet. I don't know where, so I can't give credit to the creator. This script has served me well in creating...

You probably can, but why would you? Don't you have access to the instance?

If you script changing the authentication mode within SSMS you see the "xp_instance_regwrite" is called. So the...