86 reputation
5
bio website
location
age
visits member for 1 year, 9 months
seen Mar 6 at 13:28

Jul
25
accepted Which Edition Of SQL Server Is On The Disc?
Jul
25
asked Which Edition Of SQL Server Is On The Disc?
Mar
22
awarded  Teacher
Mar
22
revised Unique indexed column in where clause and mysql execution after finding first row
added 541 characters in body
Mar
22
answered Unique indexed column in where clause and mysql execution after finding first row
Mar
22
comment Does the SQL Server Backup Database Command also backup views from a Database?
Many thanks. After a bit of investigation, turns out the sql agent service had been stopped on the server running the Backup command - something I completely overlooked. D'oh!
Mar
22
accepted Does the SQL Server Backup Database Command also backup views from a Database?
Mar
22
asked Does the SQL Server Backup Database Command also backup views from a Database?
Nov
23
comment Invalid data types in restore headeronly resultset
Many thanks for a good and clear answer. Q3) was really just asking why I didn't get an error if headeronly returned uint64 and the column in my table was type bigint. But I do believe that's now been answered :) With regards to my current scenario - I've been asked to write scripts to automate (with SSMS Job Agent) our back-up process. This involves taking .baks from the DBs on our dev server here and storing & restoring them to a second machine. I included the compression columns as I was just trying to mimic the table given in the resultset. This is still one of my first ventures in SQL.
Nov
23
accepted Invalid data types in restore headeronly resultset
Nov
23
asked Invalid data types in restore headeronly resultset
Nov
19
comment Backup SQL DataBase to C$
Thank you very much for an informed and concise answer. I currently am sharing the Backups folder, as you're suggesting, and using that to back up to (and am hoping I can convince the boss to stick with it). Again, many thanks
Nov
19
comment Backup SQL DataBase to C$
Thank youv very much for such a useful and clear answer, I'm still hoping to bring him around to using standard network shares.
Nov
19
accepted Backup SQL DataBase to C$
Nov
19
asked Backup SQL DataBase to C$
Nov
16
awarded  Editor
Nov
16
awarded  Scholar
Nov
16
awarded  Supporter
Nov
16
revised SQL Recover from .bak file with NOINIT
added 69 characters in body
Nov
16
comment SQL Recover from .bak file with NOINIT
Many thanks! Worked perfectly. You were right in your assumption that I was using SQL, apologies for leaving that out of the question. Just one last question (for now, at least), am I able to query the results of the restore headeronly function to get the max position automatically?