SQL 2005 database bases
Posted on 2006-11-21
I'm fairly inexperienced with SQL, so please bear with me.
I'm trying out using a Helpdesk application with using SQL 2005,mainly to learn a bit of SQL, and have a couple of questions -
i) We are using Veritas 9.1 BE for our backups. Is this recommended (providing we purchase the relevant Agent) for SQL as well? Can the agent restore parts of the database (e.g. certain tables) or the entire db only?
ii) How is it possible to take a manual backup of the database? In the Management Console, I am going to Backup Devices>Backup Database, but seem unable to backup the db and also add a new location for the files due to the following message;
Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
iii) Is there any method of 'viewing' the data in the db as there is in, say MS Access?
iv) Say one of the users is named UserA. The HD application stores this once I add him for the first time, but I'm not sure where? Also, if User A changes his name to User B, how can I make wholesale changes to the DB?
v) The app has a front end to run SQL queries, e.g. status= 'open'. Is it possible to run this on the DB itself to see what info comes up?