485 reputation
37
bio website
location Boston, MA
age
visits member for 2 years, 2 months
seen Feb 12 at 20:41

SQL Server Admin and developer working in the healthcare industry. I like bacon and HIPAA


Feb
24
awarded  Yearling
May
22
awarded  Caucus
May
22
awarded  Constituent
Feb
24
awarded  Yearling
Jan
23
answered Should a SQL Server TempDB space be allowed to be reclaimed?
Jan
18
comment SQL Server transaction log - shrinking and reattaching
To elaborate on what MicSim said, shrinking will heavily fragment the database. This will destroy performance. As for your process. Can you do this in a maintenance window? Theres a lot of risk doing it this way. Even though you could take and restore transaction log backups and restore onto the this new database. You'll run into issues if the backups chain gets broken. I'd definitely avoid this approach.
Jan
3
answered Thought about this SQL Server backup plan?
Dec
28
comment Remote database connection problem?
Check again to make sure the service is running and also check the event logs. Also is this a named instance?
Dec
28
answered SQL Server Log Shipping: Where is the hottest IO during RESTORE LOG: To db or to log?
Dec
27
comment Which SQL Server Express edition is right for me?
If the backups go to a specific location, you can check for the most recent backup. if its been a while you can readd the task in Task Scheduler
Dec
27
comment Which SQL Server Express edition is right for me?
Then you can just issue a BACKUP Database command as you would any other request to sql server.
Dec
27
awarded  Commentator
Dec
27
comment How to compare two SQL Servers instance level objects for a migration?
This would not be a good idea. If its moving to a shared instance copying over the system data bases would change configuration options, as well as issues with agent jobs, logins, and even other databases on the server.
Dec
27
comment Which SQL Server Express edition is right for me?
Yes, I was suggesting that. However, Billinkc has a great suggestion to use the Windows Task Scheduler. I would consider that option strongly for the backups as Then the app will not need to make the backup requests. You could have it as a scheduled reoccurring task task without needing to worry about the application running.
Dec
27
comment Which SQL Server Express edition is right for me?
Yes you can grab SQL Express as a download from microsoft.com/en-us/download/details.aspx?id=29062
Dec
27
comment Which SQL Server Express edition is right for me?
From the sounds of it, you should be ok with the base express install. Keep in mind this will not add any tools such as management studio. If you need those on the users machine, you can install the "with tools" express edition. In your application to perform backups you'll need to create an process by which your application will occasionally initiate a BACKUP DATABASE command against SQL Server to take backups. As for the reports, It looks like iReports will just query against the local database to generate the reports. So you should still be good with a basic version of express.
Dec
27
comment Which SQL Server Express edition is right for me?
@jcolebrand You are correct, Visual Studio does in fact come with a SQL Express instance.
Dec
27
comment Which SQL Server Express edition is right for me?
No. You would need the sql agent service for that.
Dec
27
awarded  Critic
Dec
27
revised Which SQL Server Express edition is right for me?
added 204 characters in body