Exactly.Why would you ever roll back or restore because of a data entry mistake? Those kinds of problems should be fixed on the front end. Each of the first three answers would require any other data to be re-entered. So tell the guy that screwed up to do it over. I suppose it's possible that the […]
2004-08-27
Hey everyone,here's the situation.I have a couple of servers.I need to migrate all databases from one to the other.I was able to do a bulk detach.I can then copy the files over.I was wondering if anyone has a script example of how to loop and issue a reattach statement for all databases.Thanks in advance for […]
2004-07-07
Thanks Jack,As it turns out I'll be moving to SQL 2000 very soon now, so this will become useful almost immediately. I'm running tests this week.
2004-03-30
If you have a non-central site down and intend to perform disaster recovery and are doing snapshot replication, maybe the following will work.Set us a subscriber pull option to the publication, only to be ran when the subscriber site requests (in this case when disaster occurs).The publication should still be available from the distributor and […]
2004-03-15
As noeld said make sure to read the knowledge base article. Also follow the link to all the referenced articles as well. My guess is you are running Win2003 and need to set up the MSDTC correctly before it'll work. I've had that problem several times myself.
2004-03-02
This is what i would use in such a case. select col1,col2 into #abc from tbl group by col1, col2 having count(*) > 1delete tbl from #abc where tbl.col1 = #abc.col1 and tbl.col2 = #abc.col2insert tbl select * from #abc -- Amit
2004-02-16
Thank you very much for your response! Has helped us to understand the SQL Server licensing.Imran.
2004-01-28
You can restore to an earlier point in time. Let's say you want to restore to 1 January. Restore a full backup from that day or a previous day (use WITH NORECOVERY). Then restore any transaction log backups that may have data up to 1 January (use WITH NORECOVERY on all but the last one). […]
2004-01-23
1 reads
Thanks for straighting me out, perhaps too much holiday cheer.
2003-12-18
1 reads
Thanks. I was already thinking of doing the "alternative". It would probably be better long run as I won't have to remember to revoke everything for new users/roles. Buddy
2003-12-09
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Are you ready to take your SQL skills from theoretical to tactical? If you've...
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