PDA

Orijinalini görmek için tıklayınız : MSSQL Script İle Yedek Alırken SqlScriptPublishException Alıyorum


memetefeugur
11-01-2018, 21:27:46
Merhaba
Hosting firmasında bulunan MSSQL veritabanımın yedeğini data and shema script i ile almak istiyorum. Fakat hata ile karşılaşıyorum. Sizce çözüm ne olabilir ?
Hosting Firmasında ki Bilglier:
Sürüm: MS SQL Server 2014 Exp. || Veritabanı Boyutu: 10 MB
Bilgisayarımda kurulu olan: (Yönetici Olarak Çalıştırılıp Denenmiştir.)
MS SQL Server 2017 / 2012 Enterprise
Hata Resimleri:
https://i.hizliresim.com/W7rn68.png
https://i.hizliresim.com/jyY5vm.png
https://i.hizliresim.com/Lboapo.png
(Durumu firmaya bildirdiğimde .bak olarak yedek almamı tavsiye ediyor. .bak olarak aldım bir sıkıntı yok.)
HATA METNİ:
Microsoft.SqlServer.Management.SqlScriptPublish.Sq lScriptPublishException: An error occurred while scripting the objects. ---> Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorE xception: Failed to retrieve data for this request. ---> System.Data.SqlClient.SqlException: The query has been canceled because the estimated cost of this query (1287) exceeds the configured threshold of 30. Contact the system administrator. at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows (Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInterna l(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at Microsoft.SqlServer.Management.Smo.DataProvider.Re adInternal() at Microsoft.SqlServer.Management.Smo.DataProvider.Se tConnectionAndQuery(ExecuteSql execSql, String query) at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetD ataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.F illData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.F illDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.B uildResult(EnumResult result) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.G etData(EnumResult erParent) at Microsoft.SqlServer.Management.Sdk.Sfc.Environment .GetData() at Microsoft.SqlServer.Management.Sdk.Sfc.Environment .GetData(Request req, Object ci) at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator. GetData(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator. Process(Object connectionInfo, Request request) --- End of inner exception stack trace --- at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator. Process(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.Smo.ExecutionManage r.GetEnumeratorData(Request req) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.In itQueryUrns(Urn levelFilter, String[] queryFields, OrderBy[] orderByFields, String[] infrastructureFields, ScriptingPreferences sp, Urn initializeCollectionsFilter, DatabaseEngineEdition edition) at Microsoft.SqlServer.Management.Smo.DefaultDatabase Prefetch.PrefetchUsingIN(String idFilter, String initializeCollectionsFilter, String type, IEnumerable1 prefetchingList) at Microsoft.SqlServer.Management.Smo.GswDatabasePref etch.PrefetchUsingIN(String idFilter, String initializeCollectionsFilter, String type, IEnumerable1 prefetchingList) at Microsoft.SqlServer.Management.Smo.GswDatabasePref etch.PrefetchBatch(String urnType, HashSet1 urnBatch, Int32 currentBatchCount, Int32 totalBatchCount) at Microsoft.SqlServer.Management.Smo.DatabasePrefetc hBase.<PrefetchObjects>d__1.MoveNext() at Microsoft.SqlServer.Management.Smo.SmoDependencyDi scoverer.SfcChildrenDiscovery(HashSet1 discoveredUrns) at Microsoft.SqlServer.Management.Smo.SmoDependencyDi scoverer.Discover(IEnumerable1 urns) at Microsoft.SqlServer.Management.Smo.ScriptMaker.Dis cover(IEnumerable1 urns) at Microsoft.SqlServer.Management.Smo.ScriptMaker.Dis coverOrderScript(IEnumerable1 urns) at Microsoft.SqlServer.Management.Smo.ScriptMaker.Scr iptWorker(List1 urns, ISmoScriptWriter writer) at Microsoft.SqlServer.Management.Smo.ScriptMaker.Scr ipt(Urn[] urns, ISmoScriptWriter writer) at Microsoft.SqlServer.Management.SqlScriptPublish.Sq lScriptGenerator.DoScript(ScriptOutputOptions outputOptions) --- End of inner exception stack trace --- at Microsoft.SqlServer.Management.SqlScriptPublish.Ge neratePublishPage.worker_DoWork(Object sender, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.OnDoWork(Do WorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThrea dStart(Object argument)

VBuMaSTeR
11-01-2018, 22:14:55
Merhaba
Hosting firmasında bulunan MSSQL veritabanımın yedeğini data and shema script i ile almak istiyorum. Fakat hata ile karşılaşıyorum. Sizce çözüm ne olabilir ?
Hosting Firmasında ki Bilglier:
Sürüm: MS SQL Server 2014 Exp. || Veritabanı Boyutu: 10 MB
Bilgisayarımda kurulu olan: (Yönetici Olarak Çalıştırılıp Denenmiştir.)
MS SQL Server 2017 / 2012 Enterprise
Hata Resimleri:
https://i.hizliresim.com/W7rn68.png
https://i.hizliresim.com/jyY5vm.png
https://i.hizliresim.com/Lboapo.png
(Durumu firmaya bildirdiğimde .bak olarak yedek almamı tavsiye ediyor. .bak olarak aldım bir sıkıntı yok.)
HATA METNİ:
Microsoft.SqlServer.Management.SqlScriptPublish.Sq lScriptPublishException: An error occurred while scripting the objects. ---> Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorE xception: Failed to retrieve data for this request. ---> System.Data.SqlClient.SqlException: The query has been canceled because the estimated cost of this query (1287) exceeds the configured threshold of 30. Contact the system administrator. at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows (Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInterna l(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at Microsoft.SqlServer.Management.Smo.DataProvider.Re adInternal() at Microsoft.SqlServer.Management.Smo.DataProvider.Se tConnectionAndQuery(ExecuteSql execSql, String query) at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetD ataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.F illData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.F illDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.B uildResult(EnumResult result) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.G etData(EnumResult erParent) at Microsoft.SqlServer.Management.Sdk.Sfc.Environment .GetData() at Microsoft.SqlServer.Management.Sdk.Sfc.Environment .GetData(Request req, Object ci) at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator. GetData(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator. Process(Object connectionInfo, Request request) --- End of inner exception stack trace --- at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator. Process(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.Smo.ExecutionManage r.GetEnumeratorData(Request req) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.In itQueryUrns(Urn levelFilter, String[] queryFields, OrderBy[] orderByFields, String[] infrastructureFields, ScriptingPreferences sp, Urn initializeCollectionsFilter, DatabaseEngineEdition edition) at Microsoft.SqlServer.Management.Smo.DefaultDatabase Prefetch.PrefetchUsingIN(String idFilter, String initializeCollectionsFilter, String type, IEnumerable1 prefetchingList) at Microsoft.SqlServer.Management.Smo.GswDatabasePref etch.PrefetchUsingIN(String idFilter, String initializeCollectionsFilter, String type, IEnumerable1 prefetchingList) at Microsoft.SqlServer.Management.Smo.GswDatabasePref etch.PrefetchBatch(String urnType, HashSet1 urnBatch, Int32 currentBatchCount, Int32 totalBatchCount) at Microsoft.SqlServer.Management.Smo.DatabasePrefetc hBase.<PrefetchObjects>d__1.MoveNext() at Microsoft.SqlServer.Management.Smo.SmoDependencyDi scoverer.SfcChildrenDiscovery(HashSet1 discoveredUrns) at Microsoft.SqlServer.Management.Smo.SmoDependencyDi scoverer.Discover(IEnumerable1 urns) at Microsoft.SqlServer.Management.Smo.ScriptMaker.Dis cover(IEnumerable1 urns) at Microsoft.SqlServer.Management.Smo.ScriptMaker.Dis coverOrderScript(IEnumerable1 urns) at Microsoft.SqlServer.Management.Smo.ScriptMaker.Scr iptWorker(List1 urns, ISmoScriptWriter writer) at Microsoft.SqlServer.Management.Smo.ScriptMaker.Scr ipt(Urn[] urns, ISmoScriptWriter writer) at Microsoft.SqlServer.Management.SqlScriptPublish.Sq lScriptGenerator.DoScript(ScriptOutputOptions outputOptions) --- End of inner exception stack trace --- at Microsoft.SqlServer.Management.SqlScriptPublish.Ge neratePublishPage.worker_DoWork(Object sender, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.OnDoWork(Do WorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThrea dStart(Object argument)


SET QUERY_GOVERNOR_COST_LIMIT 0
sorgusunu çalıştırıp deneyin hocam

memetefeugur
11-01-2018, 23:03:26
SET QUERY_GOVERNOR_COST_LIMIT 0
sorgusunu çalıştırıp deneyin hocam
"Commands completed successfully."
Komut çalıştı ama işime yaramadı