Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Initial Size For DB Files


Hi All,

I need to create a brand new db in prod and I was wondering if anybody has any recomendations for initial .mdf, .ndf, and .ldf file sizes.

Thanks.


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
SQL 2005 Resize Initial Log Size: MODIFY FILE Failed. Specified Size Is Less Than Current Size.
 
I am trying to resize a database initial log file from 500M to 2M. I€™m using€?

ALTER DATABASE <DBNAME> MODIFY FILE ( NAME = <DBLOGFILENAME, SIZE = 2 ) "

 

And I'm getting "MODIFY FILE failed. Specified size is less than current size." I tried going into the database properties and setting the log file to 2M, but it doesn€™t keep the changes.

 

Any help with this process?

View Replies !   View Related
Tempdb Initial Size
We had a runaway query which built the size of tempdb to 24000mb. Then someone changed the unrestricted file growth property to restricted growth while the size was 24000mb. Now I can not reduce the initial size. I have set the property back to unrestricted file growth. I have shrunk the tempdb and available space is almost 24000mb. I have stopped sqlserver. I even deleted the existing tempdb.mdf & tempdb.ldf files. But when SQL server is restarted, the initial size is set to 24000mb. It will not let me reduce the size. Is there anything short of manipulating the system tables to reduce the size back to 500mb?

View Replies !   View Related
File Initial Size
Via t-sql, how can I query for a file's initial size?

I want the same thing one finds by :
Start SQL Server Management Studio, view, object explorer, right click [dbname], properties, files, Database files: Initial Size (MB).

Many thanks.

Anything will give up its secrets if you love it enough. -- George Washington Carver

View Replies !   View Related
How To Resize Initial Size?
Hi, I wish resize the allocated space of my DB.
It's 245GB, but the DB is 50GB.
I tryed this query:

use master
GO
ALTER DATABASE mydb
MODIFY FILE
(NAME = 'mydb_data',SIZE= 50000)
GO

but I receive an error:
Msg 5039, Level 16, State 1, Line 1
MODIFY FILE failed. Specified size is less than current size.

Can you help me?
Thanks

View Replies !   View Related
Transaction Log - Initial Size Too Big
Hi,

Currently my db size is only 6 GB but the transaction log file initial size was set to 20 GB and has grown much way beyond the db size with the autogrowth feature turn on. The database was originally a test/development DB and was migrated to a production server including the log file. This probably caused the accumulation of transactions on the log.

We run backup everyday and tried to shrinkfile and file size did not change.

Can I change the "initial size" setting of the transaction log without causing any problems? Do I need to stop the service before I made the change assuming I made the change after the backup run? Or can I change it on the fly?


Thanks in advance.

View Replies !   View Related
Changing The Log Initial Size
Folks:

Is there a way to decrease the initial size of a database/log file? I've noticed you can increase it, but if you decrease it, after you confirm the change and go checking again, you will see nothing happened.

Is there a way? Am I missing anything?!

View Replies !   View Related
Newbie Question About Initial Table Size
Hi all,

I've worked with informix for a very long time and this is my first aproach to sql server. I have an extremely simple design for a "small" database and at this moment I'm creating the tables, in informix I can assign a first extent and next extent size to the creation of the table so if your volume and growth analisys is good you can basically be sure that you will allways have contigous space on disk for your table. I'm readin BOL to see if I have that feature here but can't seem to find anything similar. Does that mean that my table data will be "fragmented" all over the primary and secondary files every time I load into them? Would it be a good practice to simulate the extents by creating a secondary file for each table with the size I require?

Any coments will be greatly appreciated :)

Luis Torres

View Replies !   View Related
Performance - Automatic Expansion Vs Setting Large Initial Size.
Hi,

We currently have a fairly new SQL server 2000 db (currently about 18mb is size) as a backend to an application (Navision). Performance seems to be below what it should be.

The db is increasing quite rapidly in size, with a lot of data scheduled to be loaded onto the db and also more and more shops and users coming onto the system with alot more transactions going onto the db.

The initial setup of the db has the database File properties set to "Automatically grow file" by "30%" and has an unrestricted file growth.

The server that the db sits on is high spec and very large disk space.

Because the database will be expanding alot and thus reaching its maximum space allocation and then performing a 30% increase in size (which I guess affects performance quite a bit??) quite regularly.

Is it best to set the intitial size of the db to a alot bigger size in the first place as we have large disk space availiable and also set the % increase bigger also.

any advice on best performance would be much appreicated.

Regards,
David

View Replies !   View Related
Data Files Size And Log Files Size
Hi!
I'm using SQL Server 2000!
How to know then Data files size and Log files size by Store Procedures or Sql query?
Thanks!

View Replies !   View Related
Changing Value Of &"Initial Size (MB)&"
I would like to increase the initial size of a SQL 2005 DB from 150 to 250 GB to prevent automatic autogrowth; would this have any impact in production if you do it on the fly?

Thanks,

Carlos

View Replies !   View Related
Changing Value Of &&"Initial Size (MB)&&"
 

I would like to increase the initial size of a SQL 2005 DB from 150 to 250 GB to prevent automatic autogrowth; would this have any impact in production if you do it on the fly?

 
Thanks,

 
Carlos

View Replies !   View Related
How To Get The Images Files Size?
Hi,
I want to retrive the images from SQL database and store into microsoft access database.
But only images file which is <than 500mb is allowed to retireve.How can i get the images files size if i just store the image file name into my sql database.(there is another folder to store images)

p@ywen.

View Replies !   View Related
MDF And LDF Files Size Command
Hi All,I want to shrink a transaction log using :USE MasterBACKUP Log test WITH truncate_onlyUSE testDBCC shrinkfile(test_log, 0)These commands will be executed from a workstation.After shrinking, I want to see the size of thetransaction log and database files. But, I do notknow what command should I use.Could anyone help me ?Thanks in advanceJohn S.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View Replies !   View Related
Different Size Of Data Files~~
hi
just wondering if any expert out there can answer my question.

i got a database separate into 3 datafiles in 3 different drives.
i will name it A, B, C.
A datafile size 30G, B datafile size 15G, C datafile size 15G.
and the drive for datafile A is about full. so is there anyway i can more some of data from A datafile to other data file? or since A+B+C =60G can i make it all 20G for each one of them by any command? thanks!!! :)

View Replies !   View Related
RESTORE DB Into Different Size Files
I have a 24gig DB that has 1 data file.
Is it possible to RESTORE the backup to a DB that has 2 files
(1 = 10gig 2 = 14gig).
Does one of the files on the the DB have to be at least 24gig to RESTORE?

View Replies !   View Related
Size Of Backup Files
I need to know how big SQL Server 7 backup files are in comparison to the database size. For example if I have a database that is 300 Mb and I do a complete backup to disk with SQL Server 7 will the backup file be about 300 Mb?

Thanks,

Mike

View Replies !   View Related
Deployed Files Reduced Size
I am wondering why deployed packages are so much smaller than built packages. What is removed and why isn't it removed when the packages are built?

I have a package that goes from 3Mb to 1.5Mb

View Replies !   View Related
Size Limit On Text Files To Import With DTS
We are trying to import an ASCII text file into SQL Server 7.0 using DTS wizard.
The file has fixed-length fields and we are trying to map the fields to the database columns.
When we get to position 4189, there is a black line displayed which we cannot move or delete.
We cannot map any fields after this line either. Is there a size limit on a source file? We have
tried deleting and re-adding characters at this point in case there are special characters in the
file, but that doesn't help. Needless, to say, this is very frustrating, because we also keep losing
the mappings we have already made.

Any ideas? Thanks a lot.

Connie

View Replies !   View Related
Reducing The Log Files Size In SQL Server 2000
Hi all,

I have the following data and log files:
cp_1_Data 1, 024 KB
cp_1_Log 23,149,312KB
cp_date.MDF 512,000KB
cp_Log.LDF 1,024KB


How can I reduce the capdb_1_Logto smallest as possible?

I tried the following command:



Code:


use cp
dbcc shrinkfile ('cp_1_Log', {100})




But I got error:
[Microsoft][ODBC SQL Server Driver]Syntax error or access violation

Thanks for any help:-)

Abrahim

View Replies !   View Related
Balancing Size Of Data Files In Filegroup
Due to SQL's proportional fill algorithm I'd like to have the amount of data in my data files as close to equal as possible.

File sizes before:
dat 482,895 MB 0% free
2dat 436,927 MB 3% free

I made the max size of each file 600,000 MB and added a third file 3dat also 600,000 MB. I rebuilt all the clustered indexes (and nonclustered for good measure) and unfortunately the re-balancing wasn't quite right.

File sizes after:
dat 464,761 MB 77% free
2dat 443,234 MB 73% free
3dat 309,568 MB 51% free

I only have a handful of heap tables that take up <100MB total so they're not the issue. I did do an ONLINE index rebuild. I'm not sure if an offline rebuild would have been better. I will not be able to try and offline for a few weeks though as it's time consuming and I have other tasks I need to run on this test server now.

I did a FULLSCAN rebuild on any column statistics not updated by the index rebuild but that didn't help either.

View Replies !   View Related
Disaster Recovery: Calculate DB Size Based On .dmp Files
I have a client with no backup of MASTERdb or Help_rev_devices, all I have is a couple of .dmp's of the production data. In order to run DISK REINIT I need to know the size of the database, is there any way of finding out the size of the database device, if all you have to go with is a backup dump file?

I know it won't be pretty.

`Ken

View Replies !   View Related
SQL Express-solving 4GB Size Limit By Multiple Database Files?
Hi,I am new to SQL express and try to solve the 4GB size limitation.Is there a possibility to create a new database file every time I getto the limit?How can I do that with C#? how can I create new database file everytime it gets full?Can I be connected to two database files at the same time (the full dband the new db)?thanks in advance,oren

View Replies !   View Related
Enum Ntfs Cluster Size For Files Used By Databases On Server
 

Greetings experts!
 
We are having ourself a datwarehouse with multiple 32GB servers, and disk and network infrastructure that fits with this.
I'm going through the installation and want to make sure ntfs cluster size is appropriate.
 
(Don't know if we are to SAN or local disks. It may switch at any time. If we are to use SAN, they seem capable of setting it up).
 
Q: Am i right to assume that 64 KB cluster size is the right choice for volumes containing the databases?
- I guess we'll minimize logging and use TABLOCK for both updates where IO is high.
(Please underline answers with rationale)
 
Q: How can I (with sql) ensure that files used are on volumes with 64 KB cluster size?
(I can manage the enumerating of databases and their files, it's the querying of ntfs cluster size I can't remember how to do)
 
Gorm.

View Replies !   View Related
Help With Initial Set Up
Hi,

 

I have been using a licensed copy of Visual Studio 2005 and MS SQLServer 2005 for some time but am only now trying out the Reporting Services functionality.

 

I have attempted to follow the instructions from url:

http://www.microsoft.com/technet/prodtechnol/sql/2005/usingssrswithsqlexpress.mspx

 

However despite confirming that the report services are running and also checking the configuration by following the information in the above web page I still get the following problems.

 

1. When attempting  to create a project via the wizard I get the following error: Exception has been thrown by the target of an invocation. If an  attempt is made to add a new data source I am unable to choose the data source type (eg: Microsoft SQL Server). I am not given a choice for the type, in fact the relevant drop down is blank.

 

2. A project can be created without the wizard but if I right click the Shared Data Source folder I do not see the next Pop up to set the data source parameters.

 

I assume I am missing something quite fundamental - however so far I cannot see what.

 

Thanks in advance for any advice...

 

Regards Andrew 

View Replies !   View Related
Initial SQL Password
Hi, trying to use SQL server for the first time, and it's asking for a password that I don't know. Any guidance on that? Thanks.

View Replies !   View Related
Need Help About Initial Snapshot
i have created a publication whereas i have provided a network path to its snapshop folder e.g ( \serverfolder ) at time of creating. When i try to make a Pull Subscription and follow all steps of wizards, it gives me following error "The initial snapshot for publication '---' is not yet available". can you guide me what are causes of this problem and how may i solve it?

Thanks for help.
Regards,

View Replies !   View Related
Need Some Initial Direction
Hi all.  The company I work for is looking for a new SQL server.  Where can I find information and or a tool for sizing information?  By sizing information I mean how big a pile of hardware am I going to need to run MS SQL for x number of connected users with x size database, etc.  I've been tooling around the internet and MS' site but can't find any info on this. 

Can anyone shed some light for me?

View Replies !   View Related
Initial Case Query
I want get get results in sql that are all written in UPPERCASE but I want to receive them in Initial Case format
I know UPPERCASE is UPPER
lowercase is lower
but what is Initial Case(first letter Capital in a word)

View Replies !   View Related
Initial Snapshot Error
Hi all,

I am Using Sql Server 2000 as publisher and and Sql Server Mobile Edition as Subcriber.......Now my problem is while creating publisher for one Database,in the snapshot location the Snapshot.exe is not created.

when i start synchronization it leaves me error :

Thread=304 RSCB=17 Command=SYNC Hr=80045003 The initial snapshot for publication 'DB_Invetory_imp' is not yet available. -2147201021

My publication name is DB_inventory_imp........so Any body please help me in resolving these error plzzzzzzzzzzzzzzzzz.





Regards,

Ayyappa K

View Replies !   View Related
Getting The Middle Initial From A Name Column
-- I have a first name field that sometimes contains only the first name,
-- sometimes contains the first name and the middle initial, and
-- sometimes contains the first name, a space, followed by NMI (for no middle initial)
-- how do I correctly grab the first letter of the middle initial in all cases?
-- I have been playing with patindex but its harder than I thought. guess I need a case
-- statement in addition to this. Any idea how I can do this?
-- thanks!

create table UHS_t1 (c1 varchar(20))
insert UHS_t1 select 'john a'
insert UHS_t1 select 'jeff b'
insert UHS_t1 select 'sue z'
insert UHS_t1 select 'joe nmi'
insert UHS_t1 select 'jamie'


select *, substring(c1, patindex('%[ ]%', c1)+1, 1) as middle_name
from UHS_t1
go
drop table UHS_t1

View Replies !   View Related
Display Of Initial Catalog
Hi

I'm not a sql server savvy, so I need assistance on the following two scenarios:

A customer runs a script like this (slightly larger, but I ripped away the meat)
---------------------------------------
create database test_database
go

USE [test_database]
exec sp_changedbowner 'sa'

use master;
go
sp_grantlogin 'server01CUSTOM_ADMIN';
go

use test_database;
go

-- lots of table creations, where one of the tables are TEST_TABLE

sp_addrole 'ADMIN_ROLE';
Go
sp_grantdbaccess @loginame = 'server01CUSTOM_ADMIN', @name_in_db = 'USER_ADMIN';
go
sp_addrolemember @rolename ='ADMIN_ROLE' , @membername = 'USER_ADMIN';
Go

GRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[TEST_TABLE] TO [ADMIN_ROLE]
GO
---------------------------

Now, if a person is added to the server01CUSTOM_ADMIN group, he/she should be able to do the following: (let's say it's a he)

- Create a test.udl-file (win xp). Set a provider to sql server.
- On the connection-tab enter hostname of database server in the Data Source-field and use windows NT Integrated security.
- When he now test the connection, it should work, since he has access to the database.
- Also, using the dropdown "3. Enter the initial catalog to use:", he should see SOME datatables. Not ALL, not none. The ones that he has access to.

So, if TEST_DATABASE is the only access that server01CUSTOM_ADMIN has, that database and only that one should show, right?

In my customers scenario, some databases show (irrelevant ones), but not TEST_DATABASE. In my test, I still get ALL databases. Even after I rip the guy out of the Administrators-group and Users-group. He's only a member of the CUSTOM_ADMIN-group on server01. "Test connection" succeeds, and all the databases on the server shows.

What I hope for is following questions like "He's probably sysadmin, check it" etc, so that I can systematically (using your brains) filter out the reasons for these scenarios to happen.

Thanks in advance.

View Replies !   View Related
Initial CLR Execution Slow
 

I have a SQL Server 2005 Std. Ed. 64-bit installation.  There is one instance supporting a single production database.  I have a CLR udf.  This udf uses the XMLDocument object to retrieve XML from a URL.  When the CLR udf is executed, there seems to be an initial slow response time.  Subsequent response times are very fast.  If the CLR udf is not called for a few minutes and then called, the slowdown appears again.

 

Is there something happening behind the scenes with compilation or something like that which could cause this slowdown?

 

Any guidance is appreciated.

 

Thanks in advance.

View Replies !   View Related
The Initial Snapshot For Publication '' Is Not Yet Available.
I have a transaction replication on sql2005 sp2

pushing to 3 sql servers 1 sql2000 sp3a, 1 sp2000 sp4 and 1 sp2005 sp2

 

all the servers run fine except for the sql2000 sp4  which has

done this a least once a week,

The initial snapshot for publication 'nations' is not yet available.

 

 

The server that is having the issue has lots of locks

 

View Replies !   View Related
Initial Replication Setup - HELP!
I am setting up 2005 Transacational Replication on a database that was created on SQL 2000. There are 1400 articles (tables, views, sp and functions). It takes 2.5 hours to create the snapshot. Then, once the distribution errors gets its first error, it keeps retrying and getting the same error. Q1: Can I tell it to record the error but keep going? Q2: How do I stop the distribution agent once it gets in the this state? I have been deleting the publication but that seems like overkill.

I am trying to figure out a more efficient way to identify all the articles that are going to get errors. Is there any way to test the articles to see which ones will get an error? My current process takes a long time just to identify one error (since I have to create the snapshot each time).

Linda

View Replies !   View Related
Conditional Initial Viewing
 

Okay...I have a field with year values that will continue to grow each year (2001,2002, 2003.......2007). It is called YearPlaced.  I have a parameter that defaults to year the most current year when ran but the user can specify any year they choose. This is also a drill down report, so you will be able to see all the months when you drill down into each year.  However, I always want the details to show on the 3 most current years and the details to be hidden on any other years.
I thought I had it figured out with this in the visibility expression:
=iif(Parameters!ToPlacementDateDimensionYearPlaced.label=cint(max(Fields!Year_Placed.Value)),False,true).  In this case the Parameter happens to default to 2007, which is also the max year. I know that this will not work if the user selects 2006 as their parameter.

 
I have tried several different variations to ge this to work.  I was wondering if someone could help.
 
Some thoughts I had were:
1) If I could get it to evaluate all the values in the field and then compare to the parameter.  How do you get all the values to show up in an expression for one particular field.
 
Thanks in advance.  

View Replies !   View Related
ADO Seems To Ignore Initial Catalog
I have a SQL 2005 Express installed in my machine and when I try to access it with the following Connection String:

Driver={SQL Server};Server=.SQLEXPRESS;initial catalog=xx;user id=xx;password=xx

I connect, but when I try to access any table from this database I get an error indicating that the object doesn't exist and if I use the fullname xx.table I get no errors.
What may be happening?

Thanks in advance

View Replies !   View Related
Want Initial Raws Of Database Table
HI all...
I am using MS SQL 2000 DB...from last 4 months....I want to take backup of the data from 1st january to 29th Feb 2004 and then trim this data to freeup some space in my dtabase.
Is it possible?if yes hOW?
Thanks in advance,
Chandresh here

View Replies !   View Related
Delete Log Shipping Initial Backup?
Does anyone know if you can delete the initial backup file created (xxx_init.bak) on the secondary server after setting up Log Shipping?

View Replies !   View Related
Initial Display Of Tasks In Package
This may sound a little anal-retentive, but I have a number of SSIS packages that, when I open them, the first thing I have to do is scroll to the left or up to get to where the tasks are displayed.  Even if I move the tasks right or down, they still end up in that initial position.  This happens even if I use auto arrange.
 
Is there a way for me to set the package so it has a consistent point or display at which it opens?

View Replies !   View Related
Error Downloading Initial Snapshot
Hi,
 
I'm merge replicating between SQL Server 2005 and SQL Server Compact on mobile devices. I recently had a problem with reinitialization of subscriber databases (please see my previous post, no responses yet...) which I couldn't resolve and had to get 15 subscribers to backup their dbs so I could manually restore each one onto the server. Most of the subscribers were able (yesterday) to then delete their local dbs, create new db files and sync with a snapshot. Today I'm trying to sync a new db with a newly created snapshot and getting the following errors:
 
2007/08/29 16:23:17 Thread=1118 RSCB=67 Command=SCHK Hr=8004563C An error occurred while reading the .bcp data file for the 'MSmerge_rowtrack' article. If the .bcp file is corrupt, you must regenerate the snapshot before initializing the Subscriber.  -2147199428
2007/08/29 16:23:17 Thread=1118 RSCB=67 Command=SCHK Hr=80045017 The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. -2147201001
 
The only difference from yesterday is that there was a server restart this morning. I have regenerated the snapshot but it still doesn't work. This is only affecting users with new (empty) databases, users who regenerated their dbs yesterday can sync ok.
 
I have read other posts about folder/file permissions affecting snapshot delivery, but there have been no changes to permissions since successful snapshot deliveries yesterday.
 
I would really appreciate any help with this. At the moment I have 3 users who can't use the system at all.
 
Regards,
 
Greg
 
 
 
 

View Replies !   View Related
The Initial Snapshot For Publication 'Publicationxxx' Is Not Yet Available
When I am trying to synchronize my sql server ce database with sql server 2000, I am getting this error in the Replication Monitor and Synchronization gets fail.

How to Create initial snapshot or is there any step by step configuration document available for Merge Replication with SQL server 2000 and sql ce.

View Replies !   View Related
Security Problems In The Initial Synchronization
Hello everybody, I would be thankful if you try to help me with my problem,

I am using merge replication under SQL Server 2005.

In our system there is a central database running SQL Server 2005 Enterprise Edition with a big database published for merge replication. There are too a lot of clients running SQL Server 2005 Express Edition that pull subscriptions to the central database. How the clients create subscriptions and run the synchronization process is posted below (RMO Progamming).

When running the syncrhonization process, the Distributor connects OK, the Publisher Connects OK... but when the snapshot copy process starts, the execution is halted with an init session error "unknown user name or wrong password" (more or less because I get the message in spanish ;)

I think that the problem is snapshot folder sharing permissions, but I do not kow how to solve it.

Thank you very much!

=========================== Subscription creation

subscription = new MergePullSubscription();

subscription->ConnectionContext = subscriberConn;

subscription->PublisherName = m_publisher_name;

subscription->PublicationName = m_publication_name;

subscription->PublicationDBName = m_publication_database_name;

subscription->DatabaseName = m_subscription_database_name;

subscription->HostName = m_host_name;

subscription->SynchronizationAgentProcessSecurity->Login = m_win_login;

subscription->SynchronizationAgentProcessSecurity.Password = m_win_password;

subscription->CreateSyncAgentByDefault = true;

subscription->Create();

publication->MakePullSubscriptionWellKnown(m_subscriber_name, m_subscription_database_name, SubscriptionSyncType::None, MergeSubscriberType::Local, 0);



=========================== Syncrhonization

subscription->SynchronizationAgent->Distributor = m_publisher_name;

subscription->SynchronizationAgent->DistributorSecurityMode = SecurityMode::Standard;

subscription->SynchronizationAgent->DistributorLogin= m_sql_user;

subscription->SynchronizationAgent->DistributorPassword = m_sql_user_password;

subscription->SynchronizationAgent->Publisher = m_publisher_name;

subscription->SynchronizationAgent->PublisherSecurityMode = SecurityMode::Standard;

subscription->SynchronizationAgent->PublisherLogin= m_sql_user;

subscription->SynchronizationAgent->PublisherPassword = m_sql_user_password;

subscription->SynchronizationAgent->Subscriber = m_subscriber_name;

subscription->SynchronizationAgent->SubscriberSecurityMode = SecurityMode::Standard;

subscription->SynchronizationAgent->SubscriberLogin= m_sql_user;

subscription->SynchronizationAgent->SubscriberPassword = m_sql_user_password;

subscription->SynchronizationAgent->HostName = m_host_name;

subscription->SynchronizationAgent->Status += new AgentCore::StatusEventHandler(this, &ReplicationManager::SynchronizationStatusChanged);

subscription->SynchronizationAgent->Synchronize();

View Replies !   View Related
Error Applying Initial Snapshot
Hi


Using HTTPS web synchronisation - merge replication.

I have a very strange error where it bombs out half-way through downloading the snapshot

Downloaded a total of 3 chunks.
Downloaded snapshot file 'snapshot.pre'.
Downloaded snapshot file 'myView_6.sch'.
Downloaded snapshot file 'table2_2.sch'.
Downloaded snapshot file 'table2_2.cft'.
Downloaded snapshot file 'table3_3.sch'.
Downloaded snapshot file 'table3_3.cft'.
Downloaded snapshot file 'mytestProc1_4.sch'.
Downloaded snapshot file 'mytestProc3_5.sch'.
Downloaded snapshot file 'MSmerge_tombstone.bcp'.
Downloaded snapshot file 'MSmerge_contents90_forall.bcp'.
Downloaded snapshot file 'MSmerge_genhistory90.bcp'.
Downloaded snapshot file 'sysmergesubsetfilters90.bcp'.
Downloaded snapshot file 'table2_2.bcp'.

A failure occurred when accessing 'MSmerge_contents_table290_forall.bcp' due to an operating system error [3='The system cannot find the path specified.'] during Web synchronization. Ensure that the -InternetLogin user when using basic authentication and the user running the merge when using Windows integrated authentication has been granted access to the snapshot share.

A failure occurred when accessing 'MSmerge_contents_table290_forall.bcp' due to an operating system error [3='The system cannot find the path specified.'] during Web synchronization. Ensure that the -InternetLogin user when using basic authentication and the user running the merge when using Windows integrated authentication has been granted access to the snapshot share.

The processing of the response message failed.

I've tried compressing the snapshot, and can see the bcp file in the snapshot.


HELP !!!

Bruce...

View Replies !   View Related
Initial Report Load Is Slow
Each day, the first user who launches our RS reports always gets a long wait time.  Subsequent report launches are normal.
Does anyone know what is going on?  If yes, what is the remedy?
 
Thanks

View Replies !   View Related
Slow Initial Upload Of Report From .net
Hi,
In a .net application there is a link that brings up a SSRS report.
I have noticed that if it is the first time this report is requested i.e. Application has just been opened and the report button is clicked, then it takes a while to get this report to appear on the screen. But if this report is requested again (i.e. for the second time or more) then it only takes a few moments for the report to appear on the screen.
So it seems that only the first time the report is requested it takes a longer time to get this report. Is there a way to reduce this initial load of the report?
Thanks

View Replies !   View Related
Sql Server Express Slow Initial Connection
Hi,
I use a Remote Sql Server Express instance, and I have a strange behavior.. The first connection is really slow and I don't know how to fix that.I read some posts about this topic but I didn't find the right solution.Is there a way to "keep alive" the connection between my IIS server and the SQL one ?I check the auto-close property and it sets to false.
Any help ?
Stan

View Replies !   View Related
Prevent SelectCommand From Running On Initial Load
I'm just getting started with ASP.NET and I've created a query page that displays the user’s results in a gridview.  The user can then edit, delete or sort the results.  I use two text boxes for the user to supply the query criteria (Lname and Year).  The user can provide one, both, or neither items.  When no criteria are supplied the SQL query returns all records (this is the desired result).  Here's the problem.  On the initial load the page returns all records because it is submitting the Selectcommand with the query fields blank.  Can I prevent this from happening on the initial page load but permit it on all other reloads.  I initially removed the Selectcommand from the Gridview and created a codebehind for the query button that submits the query.  The problem with this was that the selectcommand is required for all other gridview operations (i.e. if the user sorts the results or edit a record, when the page reloads no records are displayed in the gridview).  I then started to use codebehind for all possible Gridview events but this got very unwieldy.  Any suggestions would be greatly appreciated. Thanks
FZev
 

View Replies !   View Related
Initial Catalog Faulty In Connection String - Why?
Hi there, I am in the process or deploying our existing .NET 1.1 application together with its SQL Server 2000 databases to 2 new hardware platforms (one for databases and one for application). I have transferred the databases and installed the application (using our installers). I have tested the database logins and checked the database user rights - everything is fine - or so it appears to be. However, when I try to open the application it receive the following exception
[Exception: Data Source=172.16.7.1;Persist Security Info=False;UID=myAccount; password=myPassword;Connect Timeout=60;;Initial Catalog=http://xxx.xx.x.x/directory/myPage.aspxMYDATABASE;Pooling = 'false';Application Name=WEBAPP; System.Data.SqlClient.SqlException: Cannot open database requested in login 'http://xxx.xx.x.x/directory/myPage.aspxMYDATABASE'. Login fails.
Login failed for user 'myAccount'.
at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()
at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection connection, SqlConnectionString connectionOptions)
at System.Data.SqlClient.SqlConnection.Open()
at FrameWork.DataServices.DBConnect.GetInternalConnection(Int32& icnt)]
FrameWork.DataServices.DBConnect.GetInternalConnection(Int32& icnt) +655
FrameWork.DataServices.DBConnect.GetInternalConnection() +16
FrameWork.Components.DBComponent.get_m_SqlConnection() +59
FrameWork.Components.DBComponent.ExecuteReader(SqlCommand cmd, Int32 iRetry, Boolean bIgnorecase) +53
FrameWork.Components.DBComponent.ExecuteReader(SqlCommand cmd, Boolean bIgnorecase) +337
FrameWork.Components.DBComponent.ExecuteReader(SqlCommand cmd) +7
It appears as if my ADO connection string is faulty. If a manually connect using a connection string in the format I expected it to be, everything works. Here are my manual connection string:
 Data Source=xxx.xx.x.x;Persist Security Info=False;UID=myAccount; password=myPassword;Connect Timeout=60;;Initial Catalog=MYDATABASE;Pooling = 'false' What is inserting the URL that I used to open the page ahead of my Initial Catalog parameter?Any assistance will be more than welcome.CJ  

View Replies !   View Related
How Can I Conserve The Initial Zero When Convert Numeric To String Using STR()
Sorry to raise a stupid question but I tried many methods which didwork.how can I conserve the initial zero when I try to convert STR(06) intostring in SQL statment?It always gives me 6 instead of 06.Thanks a lot.

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved