meta user
network profile
| bio | website | |
|---|---|---|
| location | Boston, MA | |
| age | ||
| visits | member for | 1 year, 3 months |
| seen | 21 hours ago | |
| stats | profile views | 13 |
SQL Server Admin and developer working in the healthcare industry. I like bacon and HIPAA
|
1d |
awarded | Caucus |
|
1d |
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 |
|
Dec 27 |
answered | Which SQL Server Express edition is right for me? |
