Comments
Sort by recent activity
Dear Brian:
The syntax is used to specify some tables to sync.
Could I specify only a fews columns in a table to be synced ?
Regards,
Mago / comments
Dear Brian:
The syntax is used to specify some tables to sync.
Could I specify only a fews columns in a table to be synced ?
Regards,
Mago
I couldn't know your meaning.
My steps are :
1. Create a schema binding view for 3 column.
The data type is (int, nvarchar, ntext)
2. Set unique, clustered index on this view
=> Have error in sql server
3. I ingore to build unique, clustered index on the view. Sync two views in sql data compare, then it would sync all tables, not including the view.
If we have ntext column, that means we couldn't build a indexed view for this table to sync indexed view ? / comments
I couldn't know your meaning.
My steps are :
1. Create a schema binding view for 3 column.
The data type is (int, nvarchar, ntext)
2. Set unique, clustered index on this view
=> Have error in sql s...
Dear Brian:
Thanks for your reply. :-)
I got the problem. I found I didn't create index on the view, So the indexed view couldn't sync. But when I try to create unique indexed on it, the error is "Index cannot be created on view 'Data' because the view contains text, ntext or image columns". I check the sql server document, it said :
Columns consisting of the ntext, text, or image data types cannot be specified as columns for an index. In addition, a view cannot include any text, ntext, or image columns, even if they are not referenced in the CREATE INDEX statement
Since we couldn't use indexed view. Do you have another suggestion for rapid sync ? :< / comments
Dear Brian:
Thanks for your reply. :-)
I got the problem. I found I didn't create index on the view, So the indexed view couldn't sync. But when I try to create unique indexed on it, the error is "...
Dears:
I found you ever mentioned that indexed view sync.
I guess it may resolve our problem. Because we just used a limited data of whole table. But I try to build a indexed view and sync. The sync is done, but related tables are not synced. Could you please kindly tell us should I do any setting about indexed view sync ? Thanks!
You could make an indexed view on the table and compare the indexed views instead. Normally you can also synchronize through the indexed views and that will update the underlying tables.
/ comments
Dears:
I found you ever mentioned that indexed view sync.
I guess it may resolve our problem. Because we just used a limited data of whole table. But I try to build a indexed view and sync. The syn...
Got it. Thanks for your reply. :-) / comments
Got it. Thanks for your reply. :-)
It still didn't work if to backup two database or above at the same time.
So it's the limit of sql backup ? / comments
It still didn't work if to backup two database or above at the same time.
So it's the limit of sql backup ?
Dears:
I set "Sleep" after run the script. It won't appear the error message again. So it's okay now.
Thanks a lot. [image]
==========================================
For Each DBName In DBList.Items
Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.Run "sync.wsf " & DBName, 2, 0
WScript.Sleep 60
Next
==========================================
Regards,
Mago / comments
Dears:
I set "Sleep" after run the script. It won't appear the error message again. So it's okay now.
Thanks a lot.
==========================================
For Each DBName In DBList.Items
Set W...
petey wrote:
One command is to backup, while the other is to restore, both against the same database [TSR_20050719]. This can't be performed concurrently.
Dears:
Sorry to make you confuse.
I didn't mean to backup and to restore at the same time.
I mean if I want to backup multiple database at the same time using extended stored procedure, it shows error message. I don't know if it support concurrent backup using command line(sqlbackup.exe) at the same time. But in my test, it doesn't work using extended stored procedure.
(Please ignore restore sql, it's no matter with the problem. The other database backup sql is alike as the backup sql, but has different database name.)
Regards,
Mago / comments
petey wrote:
One command is to backup, while the other is to restore, both against the same database [TSR_20050719]. This can't be performed concurrently.
Dears:
Sorry to make you confuse.
I ...
It's not a bug, but really very strange.
I use "ADODB" object. I already enlarged connection and command time out. It's useless. Even, I modify default value of remote query timeout in sql server. It still don't work.
If backup procedure executes over 40 secs, it's always return error message and quit vbs.
Could you please try to review this problem ?
Thanks a lot. / comments
It's not a bug, but really very strange.
I use "ADODB" object. I already enlarged connection and command time out. It's useless. Even, I modify default value of remote query timeout in sql server. ...
It's timeout when master..sqlbackup execute more than 40 sec in vbs.
I use "provider=sqloledb" to do backup/restore.
It's a bug about extented stored procedure ?
It seems okay when execute in command line, but I need to remote backup. Do you have any idea for that ? Thanks a lot. / comments
It's timeout when master..sqlbackup execute more than 40 sec in vbs.
I use "provider=sqloledb" to do backup/restore.
It's a bug about extented stored procedure ?
It seems okay when execute in comma...