You can use imprt/export option of SQL server 2005. Its kind of GUI. Rigth click on DB --> all task ---> export/import ---> then give db name etc...
Hi Friends, If you put a view on a 1 billion row table for data processing. Getting the min date etc. What wouldyou say the process time would be?...
Hi Friends, I am trying to create a backup maintanence plan through Management Studio. when I saved this plan its give me following error: "apply...
for any reason if part of Db get corrupt & I have to restore some filegroup then I think I have to take whole db down. In multiple db some part will...
My main concern is from avilaiblity/recovery & backup point. I read that u have to take whole database into single user mode to restore a single file...
Hi Friend, I m in the middle of designing of a big database. The expecting size of DB is 600 GB. What u guys suggest. Is it better to creat one big...
Hi Friends, Anyone have idea what is the overhead of varchar datatype in SQL server 2005. I remember that in SQL server 2000 its 1 or 2 bytes...
Hi Friends, I have set unlimited growth of database in option but after some point my database do not grow & give error. Any light on this ? thanks...
Hi Friends, I have one question here. Do SQL Server 2005 provide data encryption at database level in cluster mode ? I know Sql 2005 provide data...
Hi Friends, I have a doubt here. If I define a table as follows: Create table xxxx.table_name (Unique_keyinteger, Column1date,...
Hi Friends, I need ur help in one of issue. Please suggest... Does SQL Server 2005 support an XML datatype? If so, can you explain to me how an...
Is this solve your problem ? Because this error generally come when some objects are created under user schema. I think ur user must have some object...
Thanks friends for ur suggestion & help. MAST ITS IMPOSSIBLE TO DEFEAT A PERSON WHO NEVER GIVES UP.
Hi friends, I need a your help. Could you please tell me any good book on SQL server 2005 for DBAs. Thanks a lot for your help in advance. Regards,...
Thanks Luis for your response. Do you know if the statistics are updated by making a FULL SCAN of the table or if the data is sampled and...
Hi Shashank, Thanks for ur help but that link didnt solve my problem. Could anyone help on that ? Thanks a lot in advance. MAST ITS IMPOSSIBLE TO...
Hi, DBCC DBREINDEX updates Index statistics. Does it use FULLSCAN or use the sample size. Please let me know. Thanks !! MAST ITS IMPOSSIBLE TO...
Hi Friend, I dont have access to direct box on my Database server (because of security reason). But I come to know that CPU utilization of the server...
I didn't get u. How can u restore database from MDF & LDF files. R u restoring from backup file or from MDF & LDF file ? Please clear... If u were...
Hi, Thanks for your response. The problem with me is that I can't share folder on server A becuase of some security reason. Secondly backup file...
Separate names with a comma.
