Reputation
545
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
3 8
Impact
~39k people reached

  • 0 posts edited
  • 1 helpful flag
  • 25 votes cast
Sep
24
awarded  Autobiographer
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
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 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?
@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?
Dec
27
answered Remote database connection problem?
Dec
26
awarded  Citizen Patrol