I would suggest that you create a new database on the same server. You then need to retrive info on the datbase you setup using sp_helpdb NewDatabase. This together with info from the original database can be used in the following query to restore the database into the new location.restore database DatabaseName from disk = 'G:\..\DatabaseBackup.BAK' […]
2005-04-14
To wirte 1 query I'll use rfrancisco's codeSELECT TOP 100 percent RIC AS RIC1,'' as SVCode, count(*) FROM YourTable WHERE Compliant = 1 GROUP BY RICUNION ALLSELECT top 100 percent '' as RIC1, SVCode, count(*) FROM YourTable WHERE Compliant = 1 GROUP BY RIC, SVCodeORDER BY RIC1 DESC, SVCode
2005-04-05
Changing a cluster name is fraught with problems, I speak from experience < grin >, moving the databases about is fine, I have 8 environments where we do this on a regular basis - if you're going to move the logins with master make sure you recreate your servers with the databases in the same dbid […]
2005-04-05
>> Too much of activity on the publisher which coused a delay in updating the subscriber and hence the distribution database kept growing since the log reader continued doing what its supposed to do. That would be the only reason i could think of.
2005-03-02
I/O wize perfer the 6*.... but also provide the chanels ! or you may encounter chanel-queues.
2005-02-25
No problem, glad you help. There are definitely some simple "best practices" to follow, but you are right that there is lot of ignorance regarding these. And people still argue against these practices, or actually recommend breaking them (as you saw from the article). Craziness. People seem to figure they should BREAK the rules unless […]
2005-02-07
By Steve Jones
I was trying to update my dbatools install to test something and go this...
By James Serra
I see a lot of confusion on how classifications and sensitivity labels work in...
By Chris Yates
As someone attending the event since 2011, I would like to share my personal...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers