You'll need to 1) rename the table 2) recreate the table specifying IDENTITY for COL1 3) insert data from the original table. Note also that, to be an IDENTITY, the scale of COL1 must be zero. ie. NUMERIC(p,0) Cheers, - Mark
2003-08-06
Create a test table in your database and do some dummy transactions in a loop. Then either shrink your log file or take a log backup with NO_LOG and take a full backup
2003-07-24
1 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-24
Hi Cneuhold Thanks for information. I'm dba from Brazil and the same thing happens at my MSSQL tools here. With your suggestion, the problem is resolved.
2003-07-11
the account that starts this account belongs to the administrators group (on the domain) but that group is not in the local administrators group. I suppose this must be why it is giving me this error. I won't be able to reboot till tonight so I'll keep you posted. (crossing fingers) -Francisco
2003-07-09
There is a separate process that performs a disc to tape copy of the .bak files. And the backups are on a separate raid controller, not on the actual database server. I have looked into the maintenance plans and have suggested using that as an alternative for the very reasons you (mccork) have mentioned. Thanks!
2003-07-07
Thanks Shas3, This is a reporting db and I have additional backups on the VAX/Alpha platform. My mission-critical dbs use separate drives to store the data, the logs, and the backups. Loading is done once per week overnite so I/O is not a consideration. I am just trying to find out why the datafiles grow […]
2003-06-24
Many thanks. I'll take what you've said on board, and see what I come up with. Cheers Dave
2003-06-23
1 reads
This may not be applicable, but we have done disk migrations by using Veritas Volume Manager. Within Volume Manager you have the ability to create a mirror of the disk, replace disk signatures, etc. All while the drives are online. We have used this to migrate 1TB of data with no user impact.
2003-06-21
2 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-22
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
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