Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
5
Newest
 Informed
Impact
~451 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Jul
14
comment What's a good SQL Server backup schedule?
In most cases the active tail log can be still backed up after the failure, so the work loss exposure is minimal even if you only backup the log daily. That being said, there is usually no reason not to back it up frequently.
Jul
29
comment Splitting different parts of a string
This is very promising. If I order by parent_path, it seems to be doing what I want.
Jun
9
comment Accessing a SQL Server Denali CTP1 database with Management Studio 2012 SP1 Express
@JonSeigel yes we have run into that issue. Luckily we have managed to dig up an old installer of the CTP1, installed an other database instance and a management studio, attached the databases, scripted them out and created them back on an SQL Server 2008 R2 instance.
Mar
18
comment Accessing a SQL Server Denali CTP1 database with Management Studio 2012 SP1 Express
It's not that easy actually. I have said that 'I have a webserver' but I don't actually own it, and I'm not in the liberty to freely reinstall the SQL server instances. Installing SQL Server 2012 will also require licences not yet owned, so actually downgrading the database seems more possible. Still I don't want to touch the sql server instance if that is possible.